SQL Null set to Zero for adding
According to Allen Browne, the fastest way is to use
IIF(Column3 is Null; 0; Column3) because both
ISNULL() are VBA functions and calling VBA functions slows down the JET queries.
I would also add that if you work with linked SQL Server or Oracle tables, the IIF syntax also the query to be executed on the server, which is not the case if you use VBA functions.