Null values in Cross Tab queries

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
 
C

chas

Hi Max.

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

hth

chas
 

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

IIf statement in query, Null value change to "0" 2
Cross Tab on Queries??? 0
Cross tab query solution 4
Including Null values in query design 6
Null to Zero in a crosstab 1
Blank or Null in a Cross Tab Query in Access 2003 2
Inner join with some null values 9
Totals when one or more column has NULL values 3

Top