Report DAO with multiple SQL statement

[garywkau]

Hi everyone,

I am writing a report that is master-detail in principal. But need other data from other 2 tables. I wonder if I can construct the report DAO/query so that it contains the result set of more than one SQL statement. Thank you for your kindly help.


Gary AU

 

[Moniker]

I wonder if you can too. (Make a query based on the master table, link in the two other tables on the key, and pull the appropriate fields.)