date/time field

  • Thread starter Thread starter k11ngy
  • Start date Start date
K

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
 
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.
 
Back
Top