Results 1 to 3 of 3
  1. #1
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Formatting within Pivot Tables (Access 2003)

    I have just started to use Pivot tables. I am adding one to a db used by an Auctioneer.

    I want to analyse item outcomes for each vendor. I have added a Clearance Rate column showing the percentage of each vendor's items have been sold.

    This column automatically shows two decimal places. Can I remove the decimal places? The properties box for that column allows me to format it as a percent, but does not seem to allow me to specify the number of dec places.
    Regards
    John



  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formatting within Pivot Tables (Access 2003)

    Formatting options in a pivot table seem to be very limited. I don't think you can specify the number of decimal places. If the formatting is important, create a pivot table in Excel based on your Access data. You have much more control over formatting there.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Formatting within Pivot Tables (Access 2003)

    Thanks Hans

    In this case I will keep the Pivot in Access and put up with the decimal places.
    Regards
    John



Posting Permissions

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