IIf statement help

Topic

New Reply

Within a payroll database, I have employees that make a different rate if they work the night shift, so I thought I could have an IIf statement that would give me the night rate if they time out at 6 am otherwise give the reg rate. But when I use the statement below in my query it gives me a “Data type mismatch in criteria expression” error message.

Expr1: IIf([TIME OUT]=”06:00” ,[Night Rate],[OvrdRate])

The data type for time out is Date/Time and there is a input mask of 00:00;0;_

Reply | Quote

Replies

TRY

IIf([TIME OUT]=TimeValue(“06:00”) ,[Night Rate],[OvrdRate])

Reply | Quote

[Time Out] is date/time. “06:00” is a string. That is why you get the error message.

Reply | Quote