Report based on a new query using a previously designed report

D

Dana W. Ciardi

I have several reports already designed to my specifications that I have
used in the past for queries/tables.

I have now set-up 2 new queries - but I want to run them/print them from two
reports that I have spent hours designing/tweaking.

Is there any way to use a previously designed report with a new query
without having to re-design the same report all over again?? I hate to
waste time redoing when I could copy/paste or otherwise use my new query
with an "old" report that I have previously used for another query.

Thanks for all your help! If it wasn't for this group - I would never be
using Access - which is a wonderful program for what I am doing, even though
I barely touch on all its power!

Dana
 
D

Dana W. Ciardi

I found the answer! All I needed to do was make a copy of the report, then
click in the upper left hand corner of the copy to open the REPORT
properties, then change the Record Source! (Down arrow on right hand side
opened up a list of all my tables and queries!)

Wow - that was easy!

The hardest part was finding it in Help - I finally found it under "Binding
a blank form or report to one or more tables or queries."

Who would have thought it????

And - after I selected the new query - it did exactly what I wanted - it
used the new query results in the previously designed report!

Saved me hours and hours of work!

Hope this helps someone else......

Dana
 
Top