Data totals by date

[csarjeant via AccessMonster.com]

I have a query that provides data totals (sum of yes/no checkboxes) for all
records in a table and displays it in a report. Now I would like the user to
be able to enter a specific date range "FromDate" and "ToDate" to have the
report display only the totals of the data in that range. My date field is a
Date( ) for each new record. No matter what I seem to do, the report displays
the data totals separated by date. For example, if I enter a FromDate of
10/01/2009 and a ToDate of 10/08/2009, the report shows the resulting sums
for each date individually, records from 10/1 totals, records from 10/2
totals, records from 10/3 totals, etc. I am trying to get records from 10/1
through 10/8 totals combined. Any help is greatly appreciated. I hope my
explanation makes sense. Its been a long day.

 

[John W. Vinson]

I have a query that provides data totals (sum of yes/no checkboxes) for all
records in a table and displays it in a report. Now I would like the user to
be able to enter a specific date range "FromDate" and "ToDate" to have the
report display only the totals of the data in that range. My date field is a
Date( ) for each new record. No matter what I seem to do, the report displays
the data totals separated by date. For example, if I enter a FromDate of
10/01/2009 and a ToDate of 10/08/2009, the report shows the resulting sums
for each date individually, records from 10/1 totals, records from 10/2
totals, records from 10/3 totals, etc. I am trying to get records from 10/1
through 10/8 totals combined. Any help is greatly appreciated. I hope my
explanation makes sense. Its been a long day.

My guess is that you have a Totals query, and it's Grouping By the date field.
Change the "Totals" row under the date field from "Group By" to "Where" - the
"show" checkbox for that field should uncheck itself so the date won't be
shown nor will it group by the date.