Query/Form/Report question

[Antavas]

Currently I run reports off of a parameter query that asks me for the
location and date range of what I want to see.

What I would like to do instead is create a form that includes a drop down
box for the location and 2 boxes for my start and end dates. My goal is to
create push button reports on this form, choose my location, my dates, push
the button and have a report run for the location and date range I inputted.

My issue is that I don't know how to rebuild my queries to do this. And I
also need it so that if I don't choose a location the report brings all
location results back.

 

[Bob Larson]

Check out this sample of mine to see how to do it (all with a single query):
http://downloads.btabdevelopment.com/Samples/reports/Sample-GenericReport.zip


--

Thanks,

Bob Larson
Access MVP
Administrator, Access World Forums
Utter Access VIP

Free Access Tutorials and Resources: http://www.btabdevelopment.com