How do I quantify the instances of a value over a date range?

[Xeseus]

I have a query where I am trying to count the number of claims issued against a specific insurance company. I have no problem until I impose a date range, then I end up with a listing of the number of claims against a company per date entered. Is there a way to define a date range and still get a total of the number of claims per insurance company over the entire date range defined instead of getting a day-to-day tally?

 

[PHV]

What is your actual SQL code ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Xeseus]

Thanks PHV, it turns out that all I needed to do was to uncheck the date field, and in the total section, select WHERE on the date field!