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.
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.