I have two tables--one called Orders and one called Forecast. The orders table contains actual orders received and the Forecast table contains data that was entered previously forecasting sales for the time period (week). Each table contains a Customer Field, an Item field and a Qty field (among others). I want to generate a report that lists the Item, Qty Forecasted and Qty Ordered for a given time period so I can compare the numbers. Sometimes there will be Orders that have not forecasted and also forecasted entries that never get ordered. (The purpose of this report is to gauge how well our forecasting is). The report should include a combined list of all items in the Order and Forecast tables. I am trying to avoid making an intermediate table with a master list of all items that needs to be maintained because the Items are so dynamic (ever changing).