IsNull

  • Thread starter Mike Will via AccessMonster.com
  • Start date
M

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