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:
part_sent = 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