Results 1 to 4 of 4
  1. #1
    Gabriel2012 is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Nov 2012

    Chart, keeping number formatting from query

    Hello, my report is pulling an "accuracy" field from a query. In the query the accuracy field divides errors / orders booked for an accuracy rating and I set the formating to "percetnage". However when the graph pulls the data it shows it as a decimal, for instance 99% in the query is .99 on the line graph.

    How can I keep the percentage formatting for the graph?

    Thank you,

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    Unfortunately, format property settings don't seem to carry through to graph. Multiply by 100 to get the percentage number. Don't think can get the % symbol to show. Show it in an axis label.
    How to attach file: To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Gabriel2012 is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Nov 2012
    A sound common sense suggestion, thank you June.

  4. #4
    roaftech is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Nov 2012
    Another approach for your consideration, depending upon your application needs ...
    Before I retired I was responsible for a large database, containing details of some 2 million traffic contraventions. We needed the processing power of Access but I found that Excel was much better for graph preparation and stats presentation, so our standard procedure was to export the processed data into a spreadsheet for final publication.
    It depends on whether your application justifies the effort of setting up the procedures.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Problem formatting chart data table
    By smartin in forum Reports
    Replies: 8
    Last Post: 09-22-2012, 05:54 PM
  2. Replies: 3
    Last Post: 07-25-2012, 10:35 AM
  3. Number formatting issues in VBA.
    By Fish218 in forum Forms
    Replies: 1
    Last Post: 03-09-2012, 12:34 PM
  4. Need help formatting chart
    By NISMOJim in forum Reports
    Replies: 1
    Last Post: 08-22-2010, 10:02 AM
  5. Chart formatting
    By NISMOJim in forum Access
    Replies: 0
    Last Post: 07-31-2010, 08:52 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums