Rounding

  • Thread starter Thread starter CD Tom
  • Start date Start date
C

CD Tom

I having a problem that I can't figure out. I'm summing
up a total and them dividing it by 100, the final number
keeps rounding with no decimals.
example

the sum is 10020 and when dividing by 100 the answer
shows 100 I want it to show 100.20

Can anybody help, I've tried about everything I can think
of but nothing works.

Thanks for any help
 
I would imagine that your number field is set to Long Integer. Integers have
no decimal values.
 
I'm getting this from a table that I can't change the
format. Is there anyway that I can convert these to
double of what ever I need? I'm using a query as a feed
to the report.

Tom
 
Back
Top