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?

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

Thanks. Any suggestions on how to build the query? I have tried to count clients on more than one field but to no avail.

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

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.

Thanks! I ran separate queries, created reports for each, and then pulled them together into one report. Great idea.

How did you pull all of them together in one report?