Using Unrelated Queries to form 1 Report

Marcus20

New member
Local time
Today, 16:43
Joined
Sep 5, 2002
Messages
6
Hi,

I have 4 unrelated queries that are all the result of calculated queries themselves. For instance one query works out the total number of things sold, whilst another may work out how many things were delivered.

How can i make a report that can show all of this information without it going crazy?! I have tried putting all the queries on one query but i end up with lines and lines of records when all i should have is one for each. I can understand this as some of the queries display more than one record. But how can i sort this out on a report?

Any help would be brilliant this has been racking my brain for ages.........!!!!!!!!!!!!

Cheers.
 
Try building a report for each one, then drop each onto a master report as a subdocument with no master links.
 

Users who are viewing this thread

Back
Top Bottom