Update null value in Access
The regular SQL is null update query may fail while updating Access database. Access DB has some different is null checking system. Put the Is Null statement at the end of the where section may fix the problem.
Here is the query
UPDATE Sales SET Sales.Taxable = 0 WHERE Sales.Taxable Is Null
View On WordPress












