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

Creating a Chart on form from selected data in query. 0
Finding the right style field in VBA 0
Page numbering with Merged Document and IF statements 1
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Report counting yes/no 2
Finding the proper style field and the numbered paragraph value within the style 0
Summary Report 2

Top