Re: Always Round Down
- From: "BruceM" <bamoob@xxxxxxxxxxxxxxxx>
- Date: Wed, 9 Jul 2008 12:01:29 -0400
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
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
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,
field name is tipsize