Results 1 to 3 of 3
  1. #1
    tylerg11 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Sep 2011
    Posts
    200

    Report w/ percentile calculation

    I'm trying to build a report with a graph similar to the following. I have a range of percentage values in a query. I want to build a graphical representation of this data with the Min value and the Max value. I also want the value I filtered on to be displayed between those two values, but further, I want to indicate a percentile type of representation by indicating where along the range that specific data falls.



    For example, if most of the data is closer to the max, and that specific value is in that range, I want to display indicate where it falls when compared to the group. Any ideas? Thanks!


    Click image for larger version. 

Name:	Untitled.jpg 
Views:	7 
Size:	9.2 KB 
ID:	12299

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Possible options:

    1. a graph control with a single data

    2. code to calculate the Top property setting of an Image control with an arrow graphic.

    3. a progress bar http://support.microsoft.com/kb/304581
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Beetle is offline Unrelatable
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    Camp Swampy (Denver, CO)
    Posts
    207
    Maybe you're after something like this? (see attached db)
    Attached Files Attached Files

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

Similar Threads

  1. how to do 75th percentile for a query field
    By vicki58 in forum Queries
    Replies: 3
    Last Post: 12-20-2013, 09:27 AM
  2. Calculating percentile with query
    By glmtd in forum Queries
    Replies: 5
    Last Post: 07-26-2012, 01:35 AM
  3. Replies: 1
    Last Post: 04-04-2012, 05:08 PM
  4. Report Calculation
    By Azeez_Andaman in forum Reports
    Replies: 7
    Last Post: 10-08-2011, 11:58 PM
  5. Calculation in a report
    By jlzags in forum Access
    Replies: 3
    Last Post: 08-25-2011, 01:47 PM

Tags for this Thread

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