Calculating VAT

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Norman (anonymous_at_discussions.microsoft.com)
Date: 02/24/04 

Date: Tue, 24 Feb 2004 02:06:06 -0800

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.

Regards
Norman