Date Ranges / Report / Displaying Data

[CCHD via AccessMonster.com]

Hi,

I have a report named “rptLocalâ€. This report is made up of approx. 50
queries. How would I go about making it so that the report only displays data
ranging between two dates? I would like make it so that the user would enter
the date ranges into textboxes within a form “frmReportâ€, presses a command
button and poof the report.

Is this possible? And how?

Thanks

 

[Guest]

50 queries in a report? Wow, that's a lot of different information. If you
want each query to be filtered by the date range, you would need to set a
criteria in each query to something like

WHERE [DateField] Between Forms!frmReport!txtStart and Forms!frmReport!txtEnd

 

[CCHD via AccessMonster.com]

Duane,
Would I enter " WHERE [DateField] Between Forms!frmReport!txtStart and Forms!
frmReport!txtEnd " into the criteria of the Date Column for each query?

Thank you for the help.

50 queries in a report? Wow, that's a lot of different information. If you
want each query to be filtered by the date range, you would need to set a
criteria in each query to something like

WHERE [DateField] Between Forms!frmReport!txtStart and Forms!frmReport!txtEnd

Hi,

[quoted text clipped - 7 lines]

Thanks

 

[CCHD via AccessMonster.com]

Everything Works Great Thanks

Duane,
Would I enter " WHERE [DateField] Between Forms!frmReport!txtStart and Forms!
frmReport!txtEnd " into the criteria of the Date Column for each query?

Thank you for the help.

50 queries in a report? Wow, that's a lot of different information. If you
want each query to be filtered by the date range, you would need to set a

[quoted text clipped - 7 lines]