Re: sum two seprate fields in query

On Thu, 28 Sep 2006 10:08:01 -0700, TKM
<TKM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

How do I take two fields from two seprate tables and SUM them in a query?
[table1].[field1].what goes here[table2].[field2]
then put SUM in the total field? What would go between the two fields above
because I am not adding, subtracting etc

If you want the sum of Field1 and Field2 - i.e. if Field1 contains 2
and Field2 contains 3 you want a result of 5 - then you ARE simply
adding:

Result: [Table1].[Field1] + [Table2].[Field2]

If that's not what you want... please explain.

John W. Vinson[MVP]
.