Null values in a crosstab

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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;-
 
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?
Click to expand...

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