Multiple Record Sources in Access reports possible???

[chica3578]

I am trying to create a report in Access that uses multiple queries to show data. I have tried consolidating all the multiple queries into one, but my data gets messed up. Is there a way to use multiple record sources on a report without creating a subreport? Thanks!

 

[KenReay]

Hi

If you really cannot produce a single query, you can use DLookup() (ugh!) or open a recordset based on one of your other queries, in code within your report, and use values to populate controls in your report.

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[grnzbra]

If all the queries are similar, perhaps you could drive the report with a union query.

 

[Ryon]

you could also use sub-reports and link themto you main report