Querying a Time value?

[spinkung]

Hi all,

I have a query that is supposed to get a time value from a field and enter a string into a new field based on the time it gets.

this is what i have. Its my VERY first query ever and so i'm not sure of the syntax. I doesnt work though so i'm assuming something must be wrong. Can anyone help?

iif((hour([request date])>12)and(minute([request date])>30)), "After 12:30", "Before 12:30"

Cheers,
Spinkung.

 

[Matt Greatorex]

You don't need to compare the hours and minutes separately. I think this should do it.

IIf(Format([Request date], "HH:MM") > #12:30:00 PM#, "After 12:30", "Before 12:30")