How to specify time criteria between two long time (ie. 10:30:00 PM) fields in query wizard

[behnam]

Hi i have two text boxes called text448 and text446 which holds two long time fields (ie.10:30:00 AM, 12:32:24 PM....) In the query wizard theres a field called time and I want the condition to be the time has to be between the time range of text448 (lower bound) and text446. I tried the code bellow but it dosent recognize the AM and PM. There must be a way to work with these time fields. Thanks.

>=[Forms]![Power Outages]![Text448] And <=[Forms]![Power Outages]![Text446]

[ranman256]

Access DOES recognize am / pm.

Try:

between [Forms]![Power Outages]![Text448] And [Forms]![Power Outages]![Text446]

[behnam]

Thank you, this worked!!!