select entries keyed in after 5:30 PM


A

ali

I have a table: (for example)

Client_Name Key_in_time_date

Alle 01/01/2008 01:53:00 PM
Claire 12/02/2008 05:53:00 PM
Kingston 10/03/2008 06:25:00 PM
Steve 02/04/2008 07:56:00 PM
Timothy 07/05/2008 04:56:00 PM
James 05/06/2008 06:35:00 PM
Yuri 12/07/2008 02:40:00 PM
Nicole 22/08/2008 10:41:00 AM
Anderson 30/09/2008 10:23:00 AM
Venson 03/10/2008 10:36:00 AM
DAVID 05/11/2008 10:37:00 AM
Ray 09/12/2008 10:38:00 AM

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
I'd like to:

Select all columns with key-in time after 5:30 pm.


Thanks a lot expert !
 
Ad

Advertisements

J

John Spencer

To do that you would need to strip out the time value.

Field: TimeValue(Key_in_Time_Date)
Critiera: >= #17:30:00#

TimeValue will error if the field is ever null. So you might want to test
that.

IIF(IsDate(Key_In_Time_Date),TimeValue(Key_in_Time_Date),Null)
--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top