SUM IN COLUMN IN SQL VIEW

[antmorano]

I HAVE A TOTALS QUERY THAT CALCULATES THAT AMOUNT OF RECORDS FOR TWO
DIFFERENT QUERIES. WHAT I NEED TO DO IS TOTAL THOSE TWO NUMBERS BUT I
GET A CIRCULAR REFERENCE ERROR. HERE IS THE SQL WITHOUT THE TOTAL
PART. ANY HELP WOULD BE GREATLY APPRECIATED

SELECT SUM([TOTALS]), "H&W UNDER" AS queryNumber
FROM [H&W UNDER AGE 65 RETIREE COUNT]
UNION ALL SELECT Sum([TOTALS]), "H&W OVER" AS queryNumber
FROM [>65 H&W TOTAL RETIREES]
ORDER BY queryNumber;

-AM