Parameter Report

[Antavas]

I'm in charge of putting together Ad Hoc reports for my department. What I
want to do is create a form where any user can choose certain criteria from
drop down boxes, choose their date range and than have some pre made reports
that would generate based off of the inputted information.

How would I create a query that would return the information choosen from
drop down boxes and inputted date ranges?

 

[Allen Browne]

See:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

If you download the sample database, you will see how to create a filter
string from any combination of boxes the user chooses to use. The example
applies the filter to a form, but it's exactly the same to create the filter
for a report. In the end, you just use the filter string like this:
DoCmd.OpenReport "Report1", acViewPreview, , strWhere