A
Amir
Hi! I'll be glad if you could help me with the following:
I have 2 tables:
tblReceiptEvents:
--------------------
ReceiptEventID (PK)
ReceiptID
ProductKey
QuantityInReceipt
DeliveryPageID
tblDeliveryPagesEvents
---------------------------
DeliveryPageID (PK)
ProductKey
QuantityInDeliveryPage
I want to know for each ProductKey,
the difference between it's quantity (summed up) in the table 1,
and it's quantity (summed up) in table 2.
The purpose is to look for "mismatches" between the sums
in the *linked* tables, so I want the query to "search"
for differences in receipts and delivery pages that are
linked with the SAME DeliveryPageID value, and show
them seperately from differences in receipts and delivery
pages linked with other DeliveryPageID value.
Thank you very much for your help!!
Amir.
I have 2 tables:
tblReceiptEvents:
--------------------
ReceiptEventID (PK)
ReceiptID
ProductKey
QuantityInReceipt
DeliveryPageID
tblDeliveryPagesEvents
---------------------------
DeliveryPageID (PK)
ProductKey
QuantityInDeliveryPage
I want to know for each ProductKey,
the difference between it's quantity (summed up) in the table 1,
and it's quantity (summed up) in table 2.
The purpose is to look for "mismatches" between the sums
in the *linked* tables, so I want the query to "search"
for differences in receipts and delivery pages that are
linked with the SAME DeliveryPageID value, and show
them seperately from differences in receipts and delivery
pages linked with other DeliveryPageID value.
Thank you very much for your help!!
Amir.