Multiple queries to produce one report? (1 Viewer)

[Craig Alan]

Beginner. One table database. Two simple queries from that table. When attempting to create one report (via Wizard) using both queries I get:

"You have chosen fields from record sources which the Wizard can't connect. You may have chosen fields from a table and from a query based on that table. If so, try choosing fields from only the table or only the query."

Is Access capable of concurrently using the results from more than one query to generate a report?

Many thanks in advance.

 

[plog]

Correct. One report object, one datasource. You can however have sub-reports within reports. So you could have your report based on one datasource and the sub-report based on another.

 

[Craig Alan]

Thank you, Plog. I appreciate your reply.