This topic is locked

MS Access NZ() function replacament

9/24/2012 3:34:58 PM
ASPRunnerPro Tips and tricks
admin

MS Access users may find NZ() function useful. This function allows you to return zero when field is null. The problem is that this function won't work outside of MS Access. Here is the workaround you can use in ASPRunnerPro:

select

...

InvoiceAmount - IIF(ISNULL(PaidAmount), 0, PaidAmount) as Balance

from ...


In this example we either use PaidAmount field value or 0 if PaidAmount field is NULL.