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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert zero-length string or blank cell to null 3
Querying and Null 4
Fill Down a Column 4
Null Value 3
Problem with code 3
Filtering data for aggregate functions 1
Replace null values with zero 3
NOT function not working - can prove with screenshots 1

Back
Top