Eliminating Nulls

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

I need to eliminate nulls in my tables in order to perform
calculations. I am currently creating a new column in my
queries and using the following type of query.

ExceptionSum: IIf(IsNull([ExcpSum]),0,[ExcpSum])

The problem is that it becomes cumberson when I have many
fields that require this procedure.

How can I use VB to perform this task for an entire table
instead of long-winded querries?
 
Try using the Nz function instead, just embed it within your calcuation:

Z: nz([ExcpSum],0)*[Field2])

If you *always* convert nulls to zero (hence the nulls have no meaning) just
set the default value of the fields to 0 instead of null and then run an
update query on the table to convert all null to 0. Only do this if you are
not ever distinguishing between z null and a zero. Otherwise, use the Nz
Function.
 
Hi
You can use the is null function to test and the update query to replace it
with zero's
Why don't you prefent this problem by using default values in your table or
forms.
alfred
 
Back
Top