Extracting Times

[Bill Pugh]

I've got a field in a table called GenTime. It is in a Date/Time format, like 5/16/2005 7:00:00 PM.

What I need to do is extract from this field the time, like 7:01:00 PM to 7:59:00 PM. I just can't seem to make it work??

Help!

 

[Mile-O]

TimeValue() function.

 

[Bill Pugh]

TimeValue() function.

I've tried TimeValue() but I need al row with times from 7:01:00 AM to 7:59:00 AM. How could you use TimeValue() to do this?

Thanks

 

[Bill Pugh]

Never mind! What a brain fart I had yesterday