How to combine to related queries into one.

[Dawn]

Dear all,
I have to run a query to generate the modified data like group a contains 30
perpon, group b contains 40 person, group c contains 20 person, group d
contains 10 person. And there’s a table Relation ,which shows the relation
between some people and group, for example, alex is in charge of group a&c,
Bryant is in charge of group b…
I need to do another query to generate how many persons are managed by
people in table Relation,for example ,alex manage 50 people, Bryant manage
40 person.
How can I do one query to find out the result?
Best regards.
Dawn Wu
Shanghai, China

 

[strive4peace]

Hi Dawn,

please do not post the same question in more than one newsgroup. this
is answered in microsoft.public.access

thank you

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.accessmvp.com/Strive4Peace/Index.htm

*
have an awesome day
*

 

[Dawn]

Crystal,
I am sorry,because the first time I post it ,it returnes a mistake to show
unsuccessful.The next time I put it again, I forget to choose the same group
to put it on.and finally,there are two same questions.
Dawn

 

[strive4peace]

Hi Dawn

no problem, it sometimes take a little while to show up, have patience
<smile>

whenever you double-post, most likely someone will say something so
there is a reference for those that want to learn from your question
and those who are trying to help you

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.accessmvp.com/Strive4Peace/Index.htm

*
have an awesome day
*