Combining calculated values from two queries.

[ia04]

I have created two queries which calculates a total. I want to add the values of the two queries in a third query to give me a grand total.

When I try to create this third query, it gives me an error saying that the fields cannot be used from two different queries. So I'm just wondering whether this is possible or is there any other way of doing this.

Thanks.

ia.

 

[mhartman]

Hello

In Access, In order to do this, your tables that your queries are based on have to be related some how. When this is accomlished you can then make a query based on these two queries.
'
As an alternative, you may want to construct a Sql query using the UNION command.
Regards
Mark