I am trying to do price sheets for a customer.
A manufacturer gave me 2 Excel spreadsheets.
The first is a complete listing of product ID, Desc, and normal pricing.
The second is deviated pricing for select customers on (approx) 200 of 2,000 products.
I would like to pull this into Access and either:
Make a new table with all the products with original pricing for the 1800 items and the deviated pricing for the 200
OR
Write a query to pull form both tables with the correct pricing. So that I can then do a report with all the pricing.
Inner and outer joins don't really work because I need parts of each table.
Can someone point me in the right direction.
Thanks,
Jeb