The following is an Example Access Query I want to put make into an SQL View. The iif(isnull) is not working. Need help on writing the SQL Statement.
SELECT Column_A, Column_B, (iif(isnull(Column_A),0,Column_A))-(iif(isnull(Column_B),0,Column_B)) as Column_C From Table1
SELECT Column_A, Column_B, (iif(isnull(Column_A),0,Column_A))-(iif(isnull(Column_B),0,Column_B)) as Column_C From Table1