Query Problems

J

Jeffs

Hi,

I am in a warehouse situation and am having trouble
comparing two tables - a) Incomings and b) Outgoings. All
product is purchased for orders and no stock is physically
held in the Warehouse.
I am trying to have a query that shows the incomings and
outgoings by Material Code: Date due in:Qty due in: Date
Due Out: Qty Due out:
I would also like to show when they do not line up on the
same day.
Table l headings "Dues In" are:
Purch Doc:Line No:Vendor:MaterialCode:DelDate:Qty Due
45000000 1 67890 100000 7/18/04 1000

whilst Table 2 "Dues Out"
Delivery:Item:Material:Qty:DueOut Date:
8170000 1 100000 1000 7/18/04

many thanks, and kind regards,

Jeff
 
Top