count ALL of one field in query

[Guest]

I'd like to run a query where I count the number of a certain disease within
a time period. When I add to the query design disease, disease (count), and
date received (to select a particular date) I end up getting a count of each
disease per each date. I want a complete count of all of each disease within
the date range.

Thanks for your help.

 

[David Lloyd]

On approach is to remove the disease field from your query. This will
prevent Access from grouping on the field.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I'd like to run a query where I count the number of a certain disease within
a time period. When I add to the query design disease, disease (count), and
date received (to select a particular date) I end up getting a count of each
disease per each date. I want a complete count of all of each disease
within
the date range.

Thanks for your help.

 

[John Spencer (MVP)]

It would help if you posted the SQL text of your existing query.

GUESSING

Under DateRecieved you have Group By selected in the totals row. Change that to
WHERE. This will select the records based on your date range, but will not show
the date range or group by the DateRecieved field.

 

[John Vinson]

I'd like to run a query where I count the number of a certain disease within
a time period. When I add to the query design disease, disease (count), and
date received (to select a particular date) I end up getting a count of each
disease per each date. I want a complete count of all of each disease within
the date range.

Thanks for your help.

Use the WHERE operator on the Totals line under the date field (rather
than the default Group By).

John W. Vinson[MVP]