Linking a date to a range of dates

[Lou]

I am attempting to link a file with a ship date, to a
second file that contains date ranges (1st and last date
of each week)too obtain a price that changes weekly. Is
it possible to do this? Or is there an alternative?

 

[Duane Hookom]

Assuming you have a table with fields [FirstDate] and [LastDate] you would
add this table to your query and set the criteria under your [ShipDate]
column to:
Between [FirstDate] and [LastDate]