Retriving different columns in a query dependent on criteria
Posted on 2008-10-06
Hi, I am quite new at building Access and still have a spreadsheet mindset. I have 3 tables:
One with various products and their details
One with order dates
One which lists these products and their prices at different times (i.e. the first column has product name, the second has price in say November 2007, the third the price in February 2008, the fourth the price in July 2008).
In a query I need to be able to specify that the correct price is retrived according to the order date. In Excel I would probably use some kind of Offset and Vlookup comand, but I don't know how to approach this in Access - thanks