Hi All,
Hope someone can help with this query. I have a report that i need to alter to exclude 0 values however its not just a case of changing the format property(i think) as i want the whole line excluded not just the 0 value surpressed.
the report works off a query and the control source for the text box in question reads =Sum([Balance])
this value returns with a 0 on occassion and i would like to exclude this line when this happens.
I have attached a picture that may explain the issue a bit better
Thanks for having a look
and any help is appreciated
Tristo
Hope someone can help with this query. I have a report that i need to alter to exclude 0 values however its not just a case of changing the format property(i think) as i want the whole line excluded not just the 0 value surpressed.
the report works off a query and the control source for the text box in question reads =Sum([Balance])
this value returns with a 0 on occassion and i would like to exclude this line when this happens.
I have attached a picture that may explain the issue a bit better
Thanks for having a look
and any help is appreciated
Tristo