Summing Two Query Fields

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!
 
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!
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hopefully quick question 1
MS ACCESS query 5
How to display multiple IIf results in one column 0
how query multiple fields into one field? 1
Query-matching data with multiple choices 5
Exclude query advise 4
sum two seprate fields in query 4
Update table 5

Top