Query for selecting more than one record by user input

[nightangel73]

I have build a query that selects a particular record. The user would enter the parameter value and it gives the information requested. What I'm looking into is if a user could be able to run the query continuously so that all the particular records are in the same query and therefore I could print one report based and all queries requested instead of multiple reports due to each query.

Many thanks

[ranman256]

You need a form for the user to pick params in the report pic shown.
The query is determined from the picks, not several queries for each param.

[lfpm062010]

If I understand you correctly, you would like user to select all the records (since the user enters parameter and generate a report based on the query that uses that parameter).

If that is the case, you can create a list box (allow user to select multiple parameters) or a temp table to store all the parameters that user enters. Then use that list box or temp table to generate a final report that contain all the user entered parameters.