Query based on time of date

R

rms

I have a query with a date/time field. I'd like to write a criteria to only
show records => 5:30pm for all dates in the dataset. I know this should be
easy, but I'm stumped.
 
J

John Spencer

Field: TimeValue([YourField])
Criteria: >= #17:30:00#

or use
Criteria: >= #05:30:00 PM#

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Top