IIf statement time

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.
 
J

Jerry Whittle

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#" ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIf statement 2
Cumulative formula for word table 0
How to calulate time 3
Help with IIf statement 2
IIf statement 3
Outlook emails loading very slowly 0
IIf 2
IIf Statement used for Counting 4

Top