iif expression and time format

[TDC]

I have a table with a time field that displays a long form time (12:00:00 AM)
by default. Through a query I want to build a work shift field for grouping
these records. Below is an expression, but I know the time format is wrong.
What format do I use?

iif(([AccTime]between 6:01 and 18:00), "Day", "Night")

 

[Marshall Barton]

I have a table with a time field that displays a long form time (12:00:00 AM)
by default. Through a query I want to build a work shift field for grouping
these records. Below is an expression, but I know the time format is wrong.
What format do I use?

iif(([AccTime]between 6:01 and 18:00), "Day", "Night")

This was asnswered in another forum where you posted the
same question.

Posting the same question multiple times wastes everyone's
time. If you feel compelled to post to more than one forum,
at least cross post it by posting it to both forums in a
single post.