Results 1 to 5 of 5
  1. #1
    Grek is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Oct 2011
    Posts
    39

    Pie chart based on number of fields empty and not empty in a form

    Hello,

    In a form with many fields, I'd like to have a pie chart that would show the percentage of completion.

    Example: I have 100 fields in my form (task 1 to task 100), next to each field a combo box containing the names of my team members. Each time someone perform a task, he needs to select is name in the corresponding combo box.
    So, if 10 tasks are completed, my pie chart would show a slice of 10% Completed, and a second slice 90% Not completed.



    What would be the best way to do this?

    Many thanks,

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816

    Pie Chart/Graph

    This is one of those 'easier to show than tell' solutions. See attached example project for two solutions. Choice depends on your data structure.

    EDIT: Purpose served, file removed.
    Last edited by June7; 11-22-2011 at 04:59 PM. Reason: add title
    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
    Grek is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Oct 2011
    Posts
    39
    Thanks for your reply June07.
    However not sure how to adapt this to my database as the structure is quite different (I should have been more specific, sorry)
    I'm attaching the file so that you can have a look. I'd like to add the chart to form F_Launches and the stats would be based on all the tasks within sF_NewLaunches by counting if "Completed by" field is updated or not.
    Many thanks

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    I am confused. Form sF_NewLaunches is not on F_Launches form, sF_Tracker is.

    Your original post stated you had 100 fields. This led me to think my example Form2 would be the solution. Now I see that you don't have 100 fields, but the tasks are records instead. This means example Form1 is the correct approach. The charting will be more complicated because the tasks are categorized into two groups. I suggest you study example Form1 some more. Getting the data properly summarized in a Totals query will be the biggest hurdle. I expect will involve joining tables.

    Is it an error that two records show Task5 under Internal Task category?

    You need to use the DISTINCT modifier in the tasks combobox RowSource. The comboboxes in my example demonstrate this. Or better, use T_Tasks as the RowSource.
    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.

  5. #5
    Grek is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Oct 2011
    Posts
    39
    Thanks June, will try this.
    Indeed, Task5 twice is an error.
    Enjoy your Sunday

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

Similar Threads

  1. Return all fields even if lookup is empty
    By skarden in forum Access
    Replies: 2
    Last Post: 05-11-2011, 10:44 AM
  2. Update Query on empty fields
    By bryan in forum Access
    Replies: 3
    Last Post: 01-18-2011, 11:36 AM
  3. Check if fields are empty
    By Doggfather22 in forum Forms
    Replies: 3
    Last Post: 12-02-2010, 11:03 AM
  4. Copying into empty fields until...
    By cochi30 in forum Programming
    Replies: 8
    Last Post: 06-07-2009, 07:38 AM
  5. How to get rows with empty fields as well?
    By Orabidoo in forum Queries
    Replies: 10
    Last Post: 04-24-2009, 06:08 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