Rounding Down

J

John

Hi
I have a form which calulates and shows my VAT on each product and labour
charge.
The problem is when a value is equal to or above .5 ie 4.25
This is automatically changed to 4.26 which throws out my VAT by 1 every
time.
I need the value to be exactly what is calculated not the value after
rounding.
How can I overcome this problem.

Regards

John
 
J

John

Sorry I have made a mistake.
I meant to type 4.255 is rounded to 4.26

Regards

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding 3
historic VAT Rate lookup 10
rounding 1
rounding values in Access 4
Rounding 2
stop automatic rounding 3
1p out again! 5
Stop Rounding in Forms 2

Top