Re: Always Round Down

I was going to recommend something of the sort, but I tested first and discovered what may be some floating point difficulties. For instance, I type this into the immediate window:
?Int(100 * 3.76 / 100
but it returns 3.75. If I use 3.75 or 3.77 I get the correct result. 7.1 returns 7.09. It seems to work correctly in all cases for three decimal places. I mention this because the OP wants the value to remain as it is if there are two decimal places or less.
If this is a currency field, I don't think there is a problem. If it is a single or double, some workaround seems to be needed. I have discovered that formatting the value as currency works, as does adding .001 to the value. There may be other approaches that work better.

"Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx> wrote in message news:uQdrXdd4IHA.5012@xxxxxxxxxxxxxxxxxxxxxxx
See:
http://allenbrowne.com/round.html#RoundDown

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Nigel" <nigelben@xxxxxxxxxxxxxxxx> wrote in message
news:91BE6C86-93F4-4B7C-8696-A7C8EB465768@xxxxxxxxxxxxxxxx
I have a field on a report that whne it prints if it is 3 decimal places ie
36.175 I want it to round down to 36.17, if it is 2 or less decimla places
remain at that value,

any suggestions

field name is tipsize


.