View Full Version : Report DAO with multiple SQL statement


garywkau
02-17-2008, 09:29 PM
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
02-17-2008, 09:31 PM
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.)