Filling in null values in table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I fill in the null values of a table in Access with zeros. When
trying to add the total for the rows, it comes up blank, due to the null
values in the table. I have 14 columns, all of them containing some null
values. Is there a way to query and update all the columns with just one
query? I don't want to create 14 queries. Thanks. New to Access, old with
VBA.
 
There may be a legitimate reason to leave them Null...

Instead of totalling the field, total Nz([the field], 0)
 
Back
Top