Query based on time of date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
..
 
Back
Top