Prev: MS ACCESS
Next: Thanks for your enlighting
From: k11ngy on 18 Jan 2010 16:51
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
From: Douglas J. Steele on 18 Jan 2010 17:19
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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"k11ngy" <k11ngy(a)discussions.microsoft.com> wrote in message
news:AB204F15-0A14-461D-BFB5-EE96B7453826(a)microsoft.com...
>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


 | 
Pages: 1
Prev: MS ACCESS
Next: Thanks for your enlighting