Rounding

J

Jim Head

How do you prevent rounding of numbers when total a cloumn
of number on a report.?
 
K

Ken Snell

Without more detail, a generic answer would be to not use an integer or long
integer field when summing decimal/single/double/currency numbers. Or to
ensure that the control's Decimal Places property is not set to 0.

Can you provide a bit more info?
 
M

Marshall Barton

Jim said:
How do you prevent rounding of numbers when total a cloumn
of number on a report.?

Unless you're doing something to force it, numbers are not
rounded (whether you totaling them or not). Rounding only
occurs automatically when a number is formatted for display.

If you're talking about looking at the report and seeing
rounded numbers in the column that don't quite add up to the
total, then you should either specify more decimal digits
for the control in the column or round the numbers as part
of the totalling process.

If I sound a little vague here, its because I don't know any
details about your situation.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top