This topic is locked

MS Access NZ() function replacament

9/24/2012 3:33:12 PM
PHPRunner Tips and Tricks
Sergey Kornilov 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 PHPRunner:

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.