Hello,
I am not totally new to access, but lack some key skills.
Basically, I have a database that tracks consignment sales. I have a limited number of items (called parts), I have a consumption table and a price/spec table. The consumption table has date of consumption, part name and a variety of other informations (I am not sure is necessary for this problem). The spec/price table has each part and prices with a validity period. For example:
Part | Price | Start Date | End Date|
"A" , $50, 10/01/09, 12/31/09
"A", $55, 01/01/10, 06/30/10
"B", $40, 10/01/09, 12/31/09
"B", $35, 01/01/10, 06/30/10
I would like a query that looks at the part, the consumption date and picks the price based on the spec/price table Start Date and End Date.
Any ideas?? Do I need to post more information?
Thanks so much!
Cheers,
Matt