Text Value from Time

I have a query that looks at the time a person arrived. I would like to create a report titled Refusals by shift. I would like the query to group by shift so I tried the following criteria, but I don't get a return. There are three shifts Graves, Days and Swings.
"if" Between #12:01:00 AM# And #7:59:00 AM#="Graves"
Who is Participating?
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
try the iif() function

iif([Shift] Between #12:01:00 AM# And #7:59:00 AM#,"Graves", iif([Shift] Between #8:0:00 AM# And #5:00:00 AM#,"Day","Swing"))
poucedeleonAuthor Commented:
Awesome worked great!!!!
poucedeleonAuthor Commented:
Thank you for your quick response.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.