Link Report to Query instead of Table

[TigerTee]

I set up a table with info and spent a lot of time customizing a report based on that table. Now I realized I should have added a query as an intermediate step in order to allow me to select criteria for printing the report. Is there any way to change the report so it refers to the query and not the original table, or do I have to make a new report to go along with the new query? If that is the case, is it possible to copy the formatting of the old report to the new one? Thanks anybody!

 

[jk12]

if the query holds the same fields then it may be possible to just change the record source to the query. To do this double click on the little square that joins the margin rulers go to the all tab and the first line says record source. From there use the drop down box to select the query. Give it a go

 

[TigerTee]

That worked perfectly. Thanks. I knew there must be a way to do this simply. Just still too new to this.