I have several tables relating to clients joined by a common field: Client ID. I have created a number of queries each of which displays the number of clients for a particular field. For example, I have one query that counts that number of male and female clients, another that counts the number of clients by occupation, by language, etc. Is there anyway that I can generate a report that pulls the results of all these queries?
Multiple Queries in One Report
- Thread starter duthiev
- Start date
I think if you create a query based on the 3 queries and ensure that all the relevent fields produce the required information and then base a report on that query, you should get the result you want, you may have to do some tweaking here and there though.
John
John
OK,
What type of queries are you running Select, Crosstap? If you are able to perhaps you could upload a sample portion of your tables, queries and reports in a zip file, and I can then have a look to see if I can assist you.
John
What type of queries are you running Select, Crosstap? If you are able to perhaps you could upload a sample portion of your tables, queries and reports in a zip file, and I can then have a look to see if I can assist you.
John
Dennisk
AWF VIP
- Local time
- Today, 11:07
- Joined
- Jul 22, 2004
- Messages
- 1,649
the only way to have more than one count that I know of is to a domain aggregate instead of a column name.
Normally I count each field in a seperate query then either pull them all together in one query or create a seperate report from each query and place all the seperate reports in one main report.
Normally I count each field in a seperate query then either pull them all together in one query or create a seperate report from each query and place all the seperate reports in one main report.
