Query Sum statement help

[randell.graybill]

I have 3 queries that sum data based on 7 iif statements each.

I want to create a 4th queries that adds the totals of the 3 previous queries. But when I do it seems to be multiplying the totals and not adding them. Can you use a user created column in a query to then sum another user created column in another query?

[Bob Phillips]

In an answer yes, if a query means a formula. If it means something else, what is then, else what are the formulae?