Handling Nulls in a Crosstab

  • Thread starter Thread starter Brennan
  • Start date Start date
B

Brennan

Hello:

I have a report that is based upon a crosstab query. The
report has the following columns.

BidStatus 2000 2001 2002 2003 Total Bids


If a Project manager did not have a particular Bid Status
for a particular year, the report has a null value for
that field. How can I change that Null to show a value of
0 instead?

Any suggestions would be appreciated

Brennan
 
Brennan:

In the column that is the value field in the cross tab query, use an IIF
statement as in

Bids: Sum(IIF(IsNull([YourField]),0,[YourField]))

HTH
 
Back
Top