Time Query help

vicsalt

Registered User.
Local time
Today, 20:39
Joined
Aug 22, 2008
Messages
51
I have a query giving me a list of times, I want a query to only show values after a specific time. I have no control over the table, it saves a date/time value. Ive created a query and stripped out the time using the TimeValue command. I assumed in the criteria I could simply put >06:00:00 and it would show all records created after 6am, i get nothing in the results

Help appriciated
 
sorted

in Critera - Between #06:00:00# And #18:00:00#
 

Users who are viewing this thread

Back
Top Bottom