A97 - mainReport and subReports w/a date range

[stellJess]

Hello TechTip Experts,

I am having a problem with a mainReport and subeports. I need to create a mainReport with two subReports. Maybe i do not need subReports because i only need the grand totals from the subReports to use in calculations on the mainReport (as denominators).

The problem i am running into is that the underlying query’s criteria for the mainReport is a date range (between [startDate] and [endDate]), but the subReports will not use that same date range and provides results from the entire table/query it is based on, not just within the desired date range. so the data does not match and it takes a long time to create the report.

Based on the above, can anyone recommend a better approach and/or suggest how to make the date range work on the subReport as well as on the mainReport?

Any help is greatly welcomed!

stellJess

 

[dhookom]

Try to avoid using parameter queries. Create a small form "frmDateRange" with two text boxes "txtStart" and "txtEnd". Set your criteria to:
Between Forms!frmDateRange!txtStart and Forms!frmDateRange!txtEnd
You can do this for the main report as well as the subreports. Make sure you open the form and enter dates. Then run the report.

Duane
MS Access MVP