Null in detail, but zero in totals

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

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!
 
Don't format in the control source expression. Use the Format property to
show nothing when the value of the control is 0.
 
Duane-How do I do that?

Eric

Duane Hookom said:
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


Eric Stephens said:
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!
Click to expand...
Click to expand...
 
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


Eric Stephens said:
Duane-How do I do that?

Eric

Duane Hookom said:
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


Eric Stephens said:
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!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top