How do you add a query to a report once you have created it?

[Guest]

I have a report that was designed using one query. Now I want to include
data from antoher query....any way to acess a query from an existing report?
Thanks!

 

[Rick B]

If the existing query and the new one form a one-to-one relationship, open
the report's property box. Look for the "Record Source". Click the builder
button (...) and add the query to it.


If the two aren't a 1-to-1 realtionship, then you will most likely need to
add a subreport with it's own data source.

Rick B

 

[AlCamp]

The RecordSource query for a report can be edited via design mode to
include related data from tables other than the original, or can be changed
programatically using an SQL query statement.

Me.RecordSource = "SELECT .... etc... etc (your query here)

Al Camp