Grouping date range

[jamphan]

I have a query that includes a date field, a status field, and a count field. I am trying to write a query that will return the total number of times a certain status is used in a given date range. The problem is that the status are used throughout the date range so my query returns a 1 or however many times on that specific date that the status was used for the count field beside each status because the date is different. Is there anyway to group these so it will return a true total for the date range I select instead of the number that actually ocurred on each day?

 

[pbaldy]

Don't include the date field in the SELECT or GROUP BY clauses, just the WHERE or HAVING clause.