Automatically populating null fields in zeroes in an acces table

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I would like to know how I could construct a query or function that would
automatically add zeros to cells that have are empty (null value). For
example, if customer X has zero sales in May how can I populate the cell with
a zero instead of leaving the cell empty?

Thanks.
 
In the query builder for your update query, put this in the Update To line
for each numberic field you want to contvert:

FieldName: SomeNumber

UpdateTo: Nz([SomeNumber],0)

The Nz function returns the first argument is it not null. If it is null,
it returns the value of the second argument.
 
Thanks. Works perfectly.
--
Bob


Klatuu said:
In the query builder for your update query, put this in the Update To line
for each numberic field you want to contvert:

FieldName: SomeNumber

UpdateTo: Nz([SomeNumber],0)

The Nz function returns the first argument is it not null. If it is null,
it returns the value of the second argument.
--
Dave Hargis, Microsoft Access MVP


Bob said:
I would like to know how I could construct a query or function that would
automatically add zeros to cells that have are empty (null value). For
example, if customer X has zero sales in May how can I populate the cell with
a zero instead of leaving the cell empty?

Thanks.
Click to expand...
Click to expand...
 
There may be a reason you're not doing this, but you may want to consider
changing the default value for that field to 0 in the table definition.
 
Back
Top