Summing results of other totals

[Jon M.]

I run a query and a report that gives me totals of my fields by specific
dates I enter. For example I can run my query and report by entering;
between 1/1/2008 and 1/5/2008. I will get a summary for each individual date
where my specific fields are totalled, and I get a grand total for each date.
I am trying to figure out a way I can add a field to either my query or
report that will give me a total of the grand total for all the dates
selected. I tried adding something like =sum(date) but that was just adding
how many days there were. As always any help is always appreciated!

 

[Jon M.]

I actually answered part of my own question by adding a text box to my
report; =sum([Total]) and that gave me a grand total for my selected dates.
However I was still seeing individual dates on the report. I want to only
see a total for each of my fields summing the selected dates all on one page.