Access 2010 - Rounding down to 2 decimal places

[covstu10]

Hi everyone,

Wonder if someone can point me in the right direction.
I am trying to round down a number to 2 decimal places at all times.

Say a price of a loaf of bread is 1.69 and it is on a sale at half price, access then says it is 0.85 which it isn't, it's 0.84.
I am trying to keep the currency out of this but am using single/general number.

Would be grateful if someone could look at it, it's been driving me mad!

Thanks
Stu

 

[vbaInet]

It seems to be a common issue. Have a look at this thread:

http://www.access-programmers.co.uk/forums/showthread.php?t=204807&highlight=round