Putting Multiple SQL Queries Together

[starfox]

I have all these queries that are all aimple SQL statements calling off one database. I need to use them all in a report in MS Access. I can't figure how to put them together so I made like 10 queries. When I try to make a report it won't let me gather the infor from all the querries. Here's an example.
Query 1

SELECT count([Q2]) AS Q2Above
FROM Raid
WHERE Q2="Performed Above expectations";

Query 2

SELECT count([Q2]) AS Q2exceeded
FROM Raid
WHERE Q2="Exceeded Expectations";

I want to be able to do both of these (plus maybe three more in the same query rather than a ton of diferent ones. Anybody Got an idea? I'm sure its easy I just can figure out what it is for some reason. Any help would be great. Thanks
[sig][/sig]

 

[Amiel]

Save all of that work! : Create a table (with ten fields) to store the results from the queries (change them into append queries) and base the report on that table. Done!
[sig]<p>Amiel<br><a href=mailto:amielzz@netscape.net>amielzz@netscape.net</a><br><a href= > </a><br> [/sig]

 

[DreewToo]

DCount might suit the goal also.

Amiel's idea might work smoothly with an Update query.

Drew [sig][/sig]