Handling Nulls in a Crosstab

[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

 

[SA]

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