Combining two queries for total count

  • Thread starter Thread starter tanorris
  • Start date Start date
T

tanorris

I am wanting to arrive at a total COUNT from Query 1 and Query 2.
They both work individually, but I want the combined total. I am a
beginner and would appreciate any help you could give me. Thanks!!!

Query 1

SELECT MHL.RS, MHL.D3
FROM MHL
WHERE (((MHL.RS)=(SELECT COUNT (A)
FROM NQA
WHERE N=2 Or N=18 Or N=42
Or N=135 Or N=138 Or N=140 Or N=142
AND A=0)));


Query 2

SELECT MHL.RS, MHL.D3
FROM MHL
WHERE (((MHL.RS)=(SELECT COUNT (A)
FROM NQA
WHERE N=17 Or N=113 Or N=167 Or N=174
AND A=1)));
 
I am wanting to arrive at a total COUNT from Query 1 and Query 2.
They both work individually, but I want the combined total. I am a
beginner and would appreciate any help you could give me. Thanks!!!
Click to expand...

Just use OR logic on the criteria:

SELECT MHL.RS, MHL.D3
FROM MHL
WHERE (((MHL.RS)=(SELECT COUNT (A)
FROM NQA
WHERE N=2 Or N=18 Or N=42
Or N=135 Or N=138 Or N=140 Or N=142
AND A=0)))
OR (((MHL.RS)=(SELECT COUNT (A)
FROM NQA
WHERE N=17 Or N=113 Or N=167 Or N=174
AND A=1)));

Actually this can be simplified into a single query with a single
subquery:

SELECT MHL.RS, MHL.D3
FROM MHL
WHERE MHL.RS=(SELECT COUNT (A)
FROM NQA
WHERE (N IN (2, 18, 42, 135, 138, 140, 142) AND A=0)
OR (N IN(17, 113, 167, 174) AND A = 1);


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top