N
Norman
Hi
I have an invoice report that calculates the VAT element this works fine apart from when the pence element is computed to be half a penny eg 0.655 when the system will then round down to 0.65 instead of rounding up to 0.66.The code I am using in the control source text box is as follows: =(RoundCC([total2]*0.175)) with total2 being the vatable item. I would be very grateful if anyone could advise a solution
Regard
Norman
I have an invoice report that calculates the VAT element this works fine apart from when the pence element is computed to be half a penny eg 0.655 when the system will then round down to 0.65 instead of rounding up to 0.66.The code I am using in the control source text box is as follows: =(RoundCC([total2]*0.175)) with total2 being the vatable item. I would be very grateful if anyone could advise a solution
Regard
Norman