Eliminating Nulls

[Guest]

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?

 

[Dale Fye]

Actually, Access will automatically ignore Null values when doing
aggregate functions. There are times when doing what you are
suggesting might be needed, but not in most cases.

--
HTH

Dale Fye


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?