I imported data into table in my database of planned products and thier projected sales. I didn't want to import the data into my current product table because a lot of info is missing on these new products and some of them may not end up being sold by my company. Is there any way for me to run a report that lists all the products (current and planned) without first combining these two tables with an append query?
The reason I don't want to run an append query is that I plan on updating this import table regularly and I would like to be able to run a report as above without making the combined table every time prior to running the report.
The reason I don't want to run an append query is that I plan on updating this import table regularly and I would like to be able to run a report as above without making the combined table every time prior to running the report.