Duplicating Access Report

[RonelWebb]

Hi



Sorry I had no time to read through the threads.

I have built a report form a query and now want to use the same report and query to show a different selection in the query. Do I need to copy the query add the new selection criteria and then copy the report and point it to the new query? Your help is much appreciated.

[ranman256]

no, make a form with a list box (or combo) that has the item you want to query.
(like states) user picks from the list NEW YORK, NY
the query looks here for critera,
select * from table where [state] = forms!frmRpts!lstStates

The report uses this query, so now the report changes on whatever is selected on the form.
1 report, 1 query.

[RonelWebb]

Thank you very much! Im on the right track now.

Have a good day!