Code has been added to clipboard!

SQL ISNULL for MS Access Users

Example
SELECT Name, Price * (Unit_In_Stock + IIF(ISNULL(Unit_On_Order), 0, Unit_On_Order))
FROM Products;