Reports Using more than one query

[mike1975]

Hi,

I am trying to create a report that will need to pull data from two queries. Basically the report is monitoring the results of enquiries made to our business. I have two tables one table contains details of the original enquiry ie what product they were interested in etc the second table contains details of the result of that enquiry. I need the report to detail what the outcome of the original enquiry was ie was an appointment made? etc. I have the queries that 1/ count the different type of enquiries and 2/ detail the result of each enquiry by product - however I cannot get the report to pull from both queries - is there an easy solution???

 

[igk]

You can create a report using your first query (if I understand it correctly, it's your summary) and use second query for sub-report, linking by enquiry.