Simple Date SQL query

[ncar35b]

I have a MS Access table (event) where I would like to query the date field (eventDate) to find the closest three future dates. Could somebody please help me figure out how to write a SQL query to do this?

Thanks!

 

[PHV]

Not sure well understood the question.
Something like this ?
SELECT TOP 3 eventDate FROM event
WHERE eventDate>=[Enter #m/d/yyyy# date]
ORDER BY eventDate;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ncar35b]

That's it!! Thank you!