merging 2 tables and deleting duplicate info

[RogerD]

I am using an Access dB to summarize orders and forecasts from our customers. The information starts out as 2 excel files, then is uploaded into the database and the info is merged into 1 file.



The issue is, we have overlapping dates for orders and forecasts.

I need a query that will check for:
Part Number and date in the forecast file that match part number and date in the order file.
Any matches to both part number and date in the forecast file would be removed and the information in the orders file would be kept.

Any and all help is appreciated..
thanks
RogerD

[llkhoutx]

Join the 2 tables in an append query, append only those records in the 2nd table.

[RogerD]

Join the 2 tables in an append query, append only those records in the 2nd table.

yes, that would work, but the forecast and orders do not overlap in every instance. Perhaps, I am missing something.
I need all orders and all forecasts, except where orders and forecasts are on the same date with the same part number, when this occurs, I want the orders only.
we have from 1 to 3 weeks of firm orders (varies by customer), and forecasts for up to 3 months