Reports based on dateinput form

[aymanmb]

My reports are based on a query and a date inout form for the user to define date range of the report.

How can I enable the report to open all records if there are no date range specified by the user.

 

[KeithG]

You would have to create the SQL for your report after the user presses the button on your form. Search the forum for Dynamic SQL

 

[Moniker]

Eight minutes later, here's an example. Look at how I did it as it's very easy to do. No, I didn't make a report, but if you aren't sure how to base a report off of the query I do dynamically produce and display, then this example is going to be hard to follow. It must have like eight total lines of code!