Report based on date

[Dega]

I will have to generate several reports during the year and they are all based upon a departure date.

I have a "test report" that I am working on which is driven by a query.

The issue is that I have to go into design view of the query and change the 'criteria' to the date of departure in that column then run the report.

Is there a simpler way to generate the report based on the date (form?) as users will not know how unless it's very easy like a combo box or button to generate the report.

Thanks

[pbaldy]

You can base the report on a query that looks to a form for the criteria:

Forms!FormName.TextboxName

Typically you open a form for the user to input their criteria, then they click on a button that opens the report. Behind that button you can check the input for validity.

[Dega]

Thanks Paul

That works out good and I used the date picker for validity if that's what your talking about.

I have one more form control that needs to be included in the query. It would be a combo box with a list of destinations like, Las Vegas, Laughlin etc. (TourName)

I suppose I would just use your example again in the design view of query again and if both those conditions are met then the report would generate.

One last question ...

Is it better for me to create a form page to generate several reports (room report, customs report, customer pick-up report, etc) so a user could just open that particular form and start generating the appropriate report based upon the two form controls.

Thanks

[pbaldy]

Sorry, I missed the reply (but keep sending people to Nevada; we need the business!). Do you have this all sorted out? I've seen several ways of displaying/choosing reports. You can have a form with the input criteria and buttons for the desired reports. I've seen people use a combo box to list reports, and the user selects from that. You can have buttons for each report, but they call up a form that gathers the user input (you pass the desired report name in OpenArgs).