#access update query

[innercreationthing-blog]

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