Null in detail, but zero in totals

[Guest]

I have a report based on a query that has the following function:

Cash_For_Per: IIf([Cash_For_Period]=0,Null,[Cash_For_Period])

I've done this so that the report will not be cluttered with zero values,
and more easily bring attention to non-zero values. Only problem is, if all
the values of this function within a particular section are null, the total
in the section footer is also blank, but I WOULD like to see "0.00" in the
footer if the TOTAL is in fact zero. Any idea on how to NOT show zero values
in the detail but DO show a zero total in the footer?

Thanks!

 

[Guest]

Don't format in the control source expression. Use the Format property to
show nothing when the value of the control is 0.

 

[Guest]

Duane-How do I do that?

Eric

Don't format in the control source expression. Use the Format property to
show nothing when the value of the control is 0.

--
Duane Hookom
Microsoft Access MVP

I have a report based on a query that has the following function:

Cash_For_Per: IIf([Cash_For_Period]=0,Null,[Cash_For_Period])

I've done this so that the report will not be cluttered with zero values,
and more easily bring attention to non-zero values. Only problem is, if all
the values of this function within a particular section are null, the total
in the section footer is also blank, but I WOULD like to see "0.00" in the
footer if the TOTAL is in fact zero. Any idea on how to NOT show zero values
in the detail but DO show a zero total in the footer?

Thanks!

 

[Guest]

Open your report in design view and select the control you want to format.
Display the properties dialog and click in the Format property. Press F1. You
may need to find a link like "Number and Currency Data Types " on the Help
page. You should see an example like:
$#,##0.00[Green];($#,##0.00)[Red];"Zero";"Null"

--
Duane Hookom
Microsoft Access MVP

Duane-How do I do that?

Eric

Don't format in the control source expression. Use the Format property to
show nothing when the value of the control is 0.

--
Duane Hookom
Microsoft Access MVP

I have a report based on a query that has the following function:

Cash_For_Per: IIf([Cash_For_Period]=0,Null,[Cash_For_Period])

I've done this so that the report will not be cluttered with zero values,
and more easily bring attention to non-zero values. Only problem is, if all
the values of this function within a particular section are null, the total
in the section footer is also blank, but I WOULD like to see "0.00" in the
footer if the TOTAL is in fact zero. Any idea on how to NOT show zero values
in the detail but DO show a zero total in the footer?

Thanks!