Most current date query

[skigal]

I have a table with dates as the records and prices as the fields. I want to
do a query where a person can input a date and will get either that date's
prices or the prices on the next previous date before their input date.

<= gives me all of the dates prior to the one they input
What is the proper criteria to get the input or next prior date?

 

[Allen Browne]

See Tom Ellison's discussion:
Lookup a value in a range
at:
http://allenbrowne.com/ser-58.html

If the idea of subqueries is new, this might help:
http://allenbrowne.com/subquery-01.html

Another example:
http://www.mvps.org/access/queries/qry0020.htm