I am using Access 2010.
I have two tables, one with date ranges and prices and another table with a listing of sales by date.
I need to build a query that give me a list of sales for the price in the date range. So...
Table 1
Start Date End Date Price
1/1/2012 1/7/2012 $5.25
1/8/2012 1/12/2012 $8.95
Table 2
Load# Date
25 1/3/2012
26 1/10/2012
Query
Load# Date Price
25 1/3/2012 $5.25
So, because the load#25 from Table2 date falls within 1/1/2012 and 1/7/2012 of the Table1 it will get a price of $5.25.
I have two tables, one with date ranges and prices and another table with a listing of sales by date.
I need to build a query that give me a list of sales for the price in the date range. So...
Table 1
Start Date End Date Price
1/1/2012 1/7/2012 $5.25
1/8/2012 1/12/2012 $8.95
Table 2
Load# Date
25 1/3/2012
26 1/10/2012
Query
Load# Date Price
25 1/3/2012 $5.25
So, because the load#25 from Table2 date falls within 1/1/2012 and 1/7/2012 of the Table1 it will get a price of $5.25.