G
Guest
I have 2 tables I am trying to bring together in a query and perform a
calculation but I am not getting the calculation to work.
First table is a product Table (Prod ID, product name, description and a
Second table transacation table (Autonumber, Prod #, qty shipped and qty
received)
In the query I want to product name and the difference between qty shipped
and qty received? I am not getting a total to appear, I am not getting an
error either.
Any idea?
calculation but I am not getting the calculation to work.
First table is a product Table (Prod ID, product name, description and a
Second table transacation table (Autonumber, Prod #, qty shipped and qty
received)
In the query I want to product name and the difference between qty shipped
and qty received? I am not getting a total to appear, I am not getting an
error either.
Any idea?