Query 3 things at once/Display 3 queries together/ Query 3 things at once?

[the-m0th]

Hi Everyone,

i'm doing some audit work for someone and it's eating up most of my life. basically, i've got a list of 2500 teams, i have to call a few members of the team and conduct a short survey to find out if there are any issues. when i fill in my target table i'm using 3 queries. ones that tells me how many surveys have been completed per team. one that tells me how many surveys each team has with audit issues and one that tells me how many surveys per team without audit issues. when i run each query the lists aren't identical as there are some teams with no issues and some teams where every survey is an issue. all this comes from the same table. is there any way i can create a query that gives me all of this info in one go to save me having to trawl through 3 lists to create my results table?

thanks
wayne

 

[arnelgp]

join your queries using unique team id or something.

 

[sneuberg]

The answer might be a union query, but without knowing what these queries look like it's hard to say. I suggest posting the SQL of the three queries. Maybe that will tell us what you need, Also screen shots of the tables involved in design view would help