Looking up a date in a table help

[cultofcargo]

I have a form where, a user enters a date and the form can return one of 3 values, determined from data in another table using a DLookUP.
The data in the table has one date (the date where the season type begins) followed by the season.


Is it possible to have it stored as a date range so that the formula looks at the date and goes down to the start date one lower, then returns the season?

[rpeare]

perhaps an example of the data as it exists in the tables and an example of what you want your query to look like. I am not following your description.

[cultofcargo]

Hopefully this makes it all clear, i need it to find the season data when the date is not an exact match.

[June7]

This gets tricky:

DLookup("Season", "seasondates", "Dates=#" & DMax("Dates", "seasondates", "Dates<=#" & [firstnight_txt] & "#") & "#")

Might want to review http://allenbrowne.com/ser-36.html

[cultofcargo]

Sorry, can someone help further?
what are the # referring to in the formula?

[rpeare]

# indicates a date like ' or " indicates a text value.

[June7]

As rpeare indicated, the # is a delimiter for date parameter. Apostrophe (or a doubled quote mark) is text delimiter. Numbers and Booleans don't require any delimiter.