Null values in Cross Tab queries

  • Thread starter Thread starter Maksim
  • Start date Start date
M

Maksim

I have a crosstab query that produces a table with a large
number of Null values. They prevent me from summing up the
crosstab collumnar fields further down the road without
doing dreaded =iif(isnull(field1),0,(field1))

Does any one have any suggestions on how to handle
possible Null values in MS Office XP(2000)?

Apreciate the help!

Max
 
Hi Max.

you could use the NZ() function (NullToZero). Take a look
in VBA help for details on how to use it.

hth

chas
 
Back
Top