Totalling records in a date range

  • Thread starter Thread starter Jon M.
  • Start date Start date
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.
 
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]
 
Back
Top