Totalling records in a date range

J

Jon M.

I have a report that shows sums of various fields, grouped by date. If i run
my report based on specific dates for example between 1/1/2008 and 1/5/2008,
each date is displayed as a page in the report. i am looking to run my
report so all my fields are totalled based on the dates selected, without
displaying each individual day. I was able to add a field that totals all my
fields in the date range, but it doesn't give me the specific totals of each
field I am looking for. As always any help is greatly appreciated.
 
K

KARL DEWEY

Do not include the dates in the query but the date range as calculated field
or from a data entry form if you need that information in the report.
Date_Range: "Between 1/1/2008 and 1/5/2008"
OR
=[Forms]![YourEntryForm]![FromDate]
=[Forms]![YourEntryForm]![ToDate]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Totalling records in a given date range 3
How to show a date range in a report 8
records summary report 1
Display Specific Grouped Records 5
Data showing incorrectly in report 9
summary report w/o using subreports 1
Date Range in Reports 2
Reference controls on a dialogue form as the parameters 1

Top