Query a Query

[Mora]

I have 10 queries, all that looks at 1 table.
How can i produce a query that looks at the SUM on the first 10 queries... ie
Query 1

5
10
20

(And in the Report i have a Sum) ie: there is a report for each of these

I need to Query all the queries, and get the SUM.. and then do a calculation on the Sums'

I'm sure im missing something obvious. (but new to this)

 

[grogery]

Create a new query, UNION the fields together that you
require and then create yet another query to sum the results of the UNION query. GOod Luck!