Summing Two Query Fields

  • Thread starter Thread starter Christie
  • Start date Start date
C

Christie

I am trying to sum to fields from two separate queries. I have tried
adding them together (you know, [field1]+[field2] as well as [table1]!
[field1]+[table2]+[field2]) but that isn't working. Instead I am
getting two rows of data (one is field1 and the other is actually the
sum). Any ideas? Thanks so much!
 
I am trying to sum to fields from two separate queries. I have tried
adding them together (you know, [field1]+[field2] as well as [table1]!
[field1]+[table2]+[field2]) but that isn't working. Instead I am
getting two rows of data (one is field1 and the other is actually the
sum). Any ideas? Thanks so much!
Click to expand...

Okay, so I actually figured out that I needed to link two fields, not
just one to complete the link. Now my problem is figuring out the type
of link. I want to include all records from both. Is this possible?
 
Back
Top