DoCmd.OpenReport how to combine two queries and show both results

[behnam]

Hi guys im using the docmd.openrport method as follows

DoCmd.OpenReport "NRD", acViewReport, "R1-NRD"

this example i used a query called r1-nrd, is it posibble to combine queries, ie also add "r2-nrd" and so forth.

Thanks.

[JoeM]

You can combine the results of similarly structured queries in a Union query.
See: https://support.office.com/client/Co...3-29ec44acbc05

[NTC]

The opening of a report object (your docmd statement) and the record source of the report - - are somewhat two different topics. The desire to 'combine queries' needs further definition. One could be redefining the criteria of 1 query, potentially appending the results of multiple queries into a temp table, or joining the queries via a new 3rd query - - but it depends on you truly need.