Hi, just a quick question.
Ive made a report, and ive put in a total txt box, and in the expression builder for that txt box ive put a calculation.
=[PartTotal1]+[PartTotal2]+[PartTotal3]+[PartTotal4]+[PartTotal5]+[PartTotal6]+[PartTotal7]+[PartTotal8]+[PartTotal9]+[PartTotal10]+[PartTotal11]+[PartTotal12]+[PartTotal13]+[PartTotal14]+[PartTotal15]+[PartTotal16]
All the above are txt boxes, and are currency fields relating to a table.
The calculation works fine, when all 16 boxes have values or £0.00 values.
However, i want the boxes to not display a £0.00 value, i want the box to be blank if the value is £0.00. But if the boxes are blank, the calculation in the total does not show up even if just one of the boxes are blank, and the others contain values.
Is there a way and if so how, can i have some blank boxes and some containing values, and it to calculate it properley.
Any help is greatly appriceated.
Ive made a report, and ive put in a total txt box, and in the expression builder for that txt box ive put a calculation.
=[PartTotal1]+[PartTotal2]+[PartTotal3]+[PartTotal4]+[PartTotal5]+[PartTotal6]+[PartTotal7]+[PartTotal8]+[PartTotal9]+[PartTotal10]+[PartTotal11]+[PartTotal12]+[PartTotal13]+[PartTotal14]+[PartTotal15]+[PartTotal16]
All the above are txt boxes, and are currency fields relating to a table.
The calculation works fine, when all 16 boxes have values or £0.00 values.
However, i want the boxes to not display a £0.00 value, i want the box to be blank if the value is £0.00. But if the boxes are blank, the calculation in the total does not show up even if just one of the boxes are blank, and the others contain values.
Is there a way and if so how, can i have some blank boxes and some containing values, and it to calculate it properley.
Any help is greatly appriceated.