Date Range Value Lookup
I need to create script that will look up a price based on the date it was sold.
I have 2 tables with a relationship between the 2 ProdID fields
Product table:ProdID, Description and Image fields
Price table: ProdID, PriceDateStart, PriceDateEnd and ProdPrice fields
Hope this makes sense