How do I add two fields in a query?

[Guest]

I made a calculation in a query based of two other quieris. Now I want to use
that querys totals and another field from a different table to add them
together to get my results. How can I refer to the first query results to do
my calculation?

Example: Took two fields from two seprate tables and multiplied them to make
a new field in my query (new field 1). Now I want to take the results from
that query and add them together with a new field in the query (new field 2)
to get trhe results from that addition. How is this done? I tried using the
new name of the field I made but it wont take it. If I need to add three
seprate fileds together to get one result how is that done in a query?

 

[Jeff Boyce]

One approach might be to close your query after the first calculation/step.
Then create a new query based on the previous query, and do your next
calculation there.

Alternatively, I seem to recall that it isn't always possible to refer to a
calculated field in the same query in which it gets calculated. If you are
doing this in only one query, you'll have to do the calculation that derives
your first value inside of your calculation that does the second (you don't
get to refer to the "results" of the first). This is why I originally
suggested using two queries, in sequence.

Regards

Jeff Boyce
Microsoft Office/Access MVP