select entries keyed in after 5:30 PM

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ali - 11 Feb 2008 09:33 GMT

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 !

Signature

Allen Phailat Wongakanit

Reply to this Message

John Spencer - 11 Feb 2008 12:32 GMT

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)

Signature

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

>I have a table: (for example)
>
[quoted text clipped - 19 lines]
>
> Thanks a lot expert !

Reply to this Message