Either use todays date, a fixed date (ie 1st of current month, or Monday of
the current week), or a cell on the worksheet.

"Brad" wrote:

How would you set up the macro if you don't know the dates? I don't want any
maintenance for the dates.


"Joel" wrote:

Since your dates will always be changing I think you would want a macro so
you won't have to setup a new query every time you change the date. You can
easily create a macro automatically by using the Macro Recorder an manually
performing the query. Then make minor changes to the recorded macro make the
dates flexible.

"Brad" wrote:

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?