Hi yall,

I am so new to access and I need big time help.

I want to run query that counts the number of each status (there are seven7) in each 30 day increments or date ranges (if this is the right context). I have four ranges...[LIST][*]Day 1 to 30 -1st 30 increment[*]31 to 60- 2nd 30 day increment[*]61 to 90 - 3rd 30 day increment[*]90+ from start date
...I have the count working fine, what I can't figure out is how to do the dates when each record will have a different start date?

Can someone please help me?

You can have your query ask you to input the parameters yourself everytime you run the query, otherwise known as a parameter query in which the user interactively specifies one or more criteria values as the query runs. It further extends the flexibility of your query.
1. Open query in design view
2. Enter the following data in the Criteria row underneath your start date field:
3. Save
4. Run Query
Hope this helps,

Oh my gosh, thanks so much!