REQ: How to filter time field

[Wile Coyote]

I have a query with time values formated in short time format ie.. 10:45,
12:01, 15:36, 22:15

How do i set the criteria filter to show only those time values that would
be in the am ie..00:01 through 11:59


Thanks in advance for your help

WC

 

[John W. Vinson]

I have a query with time values formated in short time format ie.. 10:45,
12:01, 15:36, 22:15

The Format may be different from the actual Content! A date/time always
contains both a date portion and a time portion; it's stored as a Double Float
number, a count of days and fractions of a day since midnight, December 30,
1899. If you enter just a time it's actually stored as (say) 0.634456018518519
for #12/30/1899 15:13:37#.

How do i set the criteria filter to show only those time values that would
be in the am ie..00:01 through 11:59

If you're just entering times - i.e. if the date portion is 0 - then just

< #12:00:00#

If it does have a date portion (e.g. 10:45 on May 29, 2011) then apply this
criterion to Timevalue([yourfieldname]).

--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[Wile Coyote]

Thanks John,

That worked great

much appreciated

WC