IsNull

[Mike Will via AccessMonster.com]

I've tried and tried to rewrite the following section of my sql statement to
no avail using IsNull in place of Nz. I need to use this query in a web
application and must convert the Nz to IsNull.

IIf([OTHours]<10,Sum([OTHours]+Nz(([OTType]/1000000)+([OTRefusal]/10000000),0)


I've tried

IIf([OTHours]<10,Sum([OTHours]+IsNull(([OTType]/1000000)+([OTRefusal]
/10000000),0,([OTType]/1000000)+([OTRefusal]/10000000))


but receive the wrong number of argument error.

 

[giorgio rancati]

Hi Mike,
try it

 

[Mike Will via AccessMonster.com]

Kudos! That worked out great. Thank you.