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
 

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 sort order 2
Cross-tab query 2
Crosstab queries, <> and null values 3
Cross Tab Report Vs Dynamic coulmns 0
Itereate cross tab query over another query 0
Null to Zero in Crosstab Query 1
Cross tab query solution 4

Back
Top