IIf statement time

  • Thread starter Thread starter clueless
  • Start date Start date
C

clueless

I have the following IIf statement:
Detention: IIf([CarrierType] In ("Regular") And [DriverTime]>#2:15:00
AM#,"Detention",Null)

It was working when the driver time was in the 2 hour range. Now, I have a
driver time of 3:22 and it is null. What is wrong with this statement?
Thanks very much for you help.
 
Is the DriverTime 3:22 or 3:22:00 ? One is 3 minutes and the other is 3 hours.

Is the CarrierType "Regular" for that record?

What happens when you remove the "[CarrierType] In ("Regular") And" from the
IIf statement?

Removing the "And [DriverTime]>#2:15:00 > AM#" ?
 
Back
Top