hey everyone...question...i have created a report that calls a query which displays:
Language Interpreter Name Number of Clients
Arabic Mohamoud 1
Somali Mohamoud 12
Somali Sirad 5
Spanish Ana 8
Spanish Carmen 5
Spanish Jaime 8
What I would like to do is have it display:
Language Interpreter Name Number of Clients
Arabic 1
Mohamoud 1
Somali 17
Mohamoud 12
Sirad 5
Spanish 21
Ana 8
Carmen 5
Jaime 8
I have created two different queries which produce the two separate desired outcomes (Totals by language, Language breakdowns as in first example). But how do can i call both queries in one report? Or is there an easier way to go about doing this. Please help me.
Language Interpreter Name Number of Clients
Arabic Mohamoud 1
Somali Mohamoud 12
Somali Sirad 5
Spanish Ana 8
Spanish Carmen 5
Spanish Jaime 8
What I would like to do is have it display:
Language Interpreter Name Number of Clients
Arabic 1
Mohamoud 1
Somali 17
Mohamoud 12
Sirad 5
Spanish 21
Ana 8
Carmen 5
Jaime 8
I have created two different queries which produce the two separate desired outcomes (Totals by language, Language breakdowns as in first example). But how do can i call both queries in one report? Or is there an easier way to go about doing this. Please help me.
