So I will start off by saying that I am very new to Access and learning as I go, but cant seem to find and answer to this and hoping someone could help.
I have two tables, the first table has dates from January 2015-December 2016 with actual sales information (book qty, Book Amt , Net Invoice amount, Net Invoice Qty). The second table has date ranges from 6/2015 through 3/2018 with Forecasted Sales, Forecasted Dollars, etc.
I was able to bring them together to one table, however it only is pulling data from 2016 which makes sense because those dates match in the relationship. My question is does anyone know a way around that to illustrate all dates with out messing with the original data?