Question Sum Fields in 2 different tables

[pcampos]

I have a 2 tables, one for parts received "tbl_received" and one for parts sent out "tbl_sent". On both tables i have the same product and i want to display on a form the difference between the 2 so that i know how many parts i have left:

table= tbl_received
field= part_received
field data=10

table= tbl_sent
field= part_sent field data=5

I want the form to display on a box the difference between both so that it shows "Parts Available = 5"

hope it makes sense

PS. if possible i would prefer this to be done via an expression rather than writing a whole SQL query as i am quite new to Access

 

[dcb]

In a unbound text Box type:
=[Part_received] - [part_sent]

 

[pbaldy]

http://www.dbforums.com/microsoft-access/1652783-sum-fields-2-different-tables.html

 

[dcb]

http://www.dbforums.com/microsoft-access/1652783-sum-fields-2-different-tables.html

LOL - priceless!!!
As he has both values already on his form (from what i understand) I just ref the textboxes....

 

[pbaldy]

I assumed the tables could contain multiple records for each transaction type, thus the need for summing. I assume the form only contains the part number.

One of us is probably right!

 

[pcampos]

All Problem resolved... I didn't realize that i strated the same thread in what i though were different forums