date/time field

[k11ngy]

I have table with Times in them (Date/Time-Short time)

I try to run queries for example <12:00 and cannot get proper response

1. Assume short time ok in propertis?
2. How should i type in the criteria section? 12:00 or 12.00 or?

Help

Thanks

Steve

 

[Douglas J. Steele]

Do your fields contain only Times, or do they also contain Dates?

Setting the format does not change the value of the field: it only changes
how the value is displayed, which makes no impact on using it in queries.

If you do have dates and times, you'll need to create a calculated field
that uses the TimeValue function. Use < #12:00:00# as the criterion.