Results 1 to 4 of 4

Pivot Table Rounding Issues

This is a discussion on Pivot Table Rounding Issues within the Microsoft Access forums, part of the Question Forums category; I set up a pivot table recently in Access and for some reason it seems to be rounding the data ...

  1. #1
    Board Regular
    Join Date
    Mar 2003
    Location
    San Diego, CA
    Posts
    84

    Default Pivot Table Rounding Issues

    I set up a pivot table recently in Access and for some reason it seems to be rounding the data to the point where the accuracy of my data is compromised.

    When I export the data (datasheet) to excel and run pivot table there is no rounding.

    Is there a way to fix this in Access?

  2. #2
    Board Regular
    Join Date
    Apr 2007
    Location
    Pennsylvania
    Posts
    166

    Default

    Is it possible you mean decimals are being rounded? Or a control's property is rounding?
    Are these stored values or calculated values?

  3. #3
    Board Regular
    Join Date
    Mar 2003
    Location
    San Diego, CA
    Posts
    84

    Default

    yes, the decimals are being rounded in the pivot table (Access). The property is two decimal places but when the Access pivot is created, it seems to be rounding. These are stored values.

  4. #4
    Board Regular
    Join Date
    Apr 2007
    Location
    Pennsylvania
    Posts
    166

    Default

    Double clicking on the Access pivot form should open the pivot table in Excel. Format the range of values in Excel and close Excel. The resulting format should appear in the Access pivot form.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com