Linking a date to a range of dates

  • Thread starter Thread starter Lou
  • Start date Start date
L

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?
 
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]
 
Back
Top