I am trying to compare the same field in two reports to determine if the value has changed. I got the code written below which works; however, there are null values that aren't being picked up so i needed to convert them to a value to they are identified within the query.
Upon doing research i thought i could use the isnull and then put the value in it, but it says i am using wrong number of arguments with function in query expression.
SELECT Position_Database.Position, WFV.Position, Position_Database.Name, WFV.Name
FROM Position_Database LEFT JOIN WFV ON Position_Database.Position = WFV.Position
WHERE Position_Database.Name <> WFV.Name;
I thought I could do IsNull([Position_Database.Name],0)