Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Sum of Group field Rounding number

Sum of Group field Rounding number

Sum of Group field Rounding number


I have a Sum field that displays the total of a collumn. Unfortunately, the total is not correct. It is off by a few cents. I sent the field for two decimal places but it is still incorrect.

For example, if I manually added the collumn it's 45.67 cents but the report rounds off to 45.69. Any ideas?

RE: Sum of Group field Rounding number

Whaatup! Hey what is the Field size, format, and Decimal place say in the general tab when you look at the table in design view in access. Still access 97 right? When you right click and format the field in crystal, does it use Custom Style or did you select one of the formats there like [-1123.00]Also what is the grouping and in what section is the column field you are trying to summarize.

Much love to my bro's in selma!


RE: Sum of Group field Rounding number

This probably means that the fields above it are being rounded for the display, but that the actual number is being used in the summary. For example:

actual       display
10.0089      10.01
10.0089      10.01
13.4649      13.46
12.1949      12.19
45.6776      45.68

If you want the displayed totals to be summed, then replace the individual values with a formula:


Then insert a summary on this rounded value.


RE: Sum of Group field Rounding number

Hey dude.. you remember my handle..

It's weird, because use used the format to round the number to two decimals but crystal is still not totaling the field correctly. For example:

There are my amounts:


The total is 400.67
but crystal displays 400.79

When I format the field to show four decimal points my amounts are


The total is 400.6787
But crystal displays 400.6789

Any help, thanks.

BTW: Nice to see you dude.

RE: Sum of Group field Rounding number

Note that the formatting is for display purposes only, not for calculations, so if you want to sum the rounded amounts you will have follow my earlier suggestion. It is not that CR is calculating incorrectly.


RE: Sum of Group field Rounding number

Thanks lbass. I'll try it out and let you know.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close