How can I build a date filter into a report, using one field for start date and one field for end date, instead of right-click on the field column to filter?
How can I build a date filter into a report, using one field for start date and one field for end date, instead of right-click on the field column to filter?
Use a form for the criteria, and open report using that criteria ?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
You should be opening the report with the date range filters. You're asking how to do this when the report is already open? I'm not a fan of putting buttons on a report, but if you must, you could do that and have it pop up a form where you enter the dates and click this form's button to alter the recordsource property or filter property of the report. To me, that's a hack and I would simply go back to whatever form you opened the report from and do it from there.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Perhaps have a textbox for start date and a textbox for end date on the form from which the report is opened and reference those textboxes as criteria in the reports underlying query. Another way would be to use a parameterized query for the report.
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Thanks for your help. I use a form now to open the report as you guys suggested. Thanks again!!! I will be back with more questions though...