Query logic concerning dates
Given a field in a database has dates
In this example lets assume the data base the following dates
1/18/2008
9/3/2008
12/30/2008
1/27/2009
I would like the ability to enter a date and have the query pull the right
information explained below....
Any date starting with 1/18/2008 through 9/2/2008 would pull information
from the first record.
Likewise any date after 1/27/2009 will use the information from that record.
That is until another record is added.
Likewise any date before 1/18/2008 will not provide any information.
Essentially the query performs a vlookup and selects the date closest
(without exceeding) to the date inputted by the user and selects the
information from that particular record? Can this be done without inputting
those key dates in a spreadsheet or in the macro query?
|