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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:91BE6C86-93F4-4B7C-8696-(E-Mail Removed)...
>>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
>
Similar Threads
