not rounding

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have some text files in a report and im multiplying in them

[text18]*1.05 [text19]*1.05 some of the fields round and some dont
any idea why?
 
Could you give us some examples of a "Field" that rounds and a "field" that
doesn't round?

I would suggest you check the field's "size" in the table design view. If
it is integer or long integer then the field cannot contain a decimal
portion and often that propagates in calculations. It will always propagate
if you try to save into an integer field - That is the field can't store a
decimal portion, so Access rounds the number to fit (instead of giving you
an error).
 
Back
Top