Calulating two fields with same name but diffent tables

[survivo01]

I have a query where I am attempting to add two fields with same name but from different queries eg. AM tx querie Sum of Cap + PM tx querie Sum of Cap. In the caluclated fiels I do not know how to differentiate in the fourmula between the two Sum of CAP

[June7]

The query is a join of two other queries? Use the subquery names as prefix for the field names.

[AM tx].[Sum of Cap] + [PM tx].[Sum of Cap]

If you drag each field individually to columns in the design grid then view in Datasheet, should see the prefixes. Just follow the same structure in the expression.