Null values in a crosstab

[Guest]

I am using a crosstab query to generate data for a report. Many of the
crosstab values are null which is fine. In the report, I'd like these null's
to appear as "-"... in other words, a zero formatted for accounting.

I have tried entering an iif statment in the report field and in the
crosstab but I must be doing something wrong. Any ideas?

 

[Allen Browne]

Open your report in design view, and set the Format property of the text
boxes where you want a dash for null.

For example, this format would work for whole numbers:
#,##0;-#,##0;0;-

 

[fredg]

I am using a crosstab query to generate data for a report. Many of the
crosstab values are null which is fine. In the report, I'd like these null's
to appear as "-"... in other words, a zero formatted for accounting.

I have tried entering an iif statment in the report field and in the
crosstab but I must be doing something wrong. Any ideas?

In an unbound control on the report:
=Nz([FieldName],"-")