Results 1 to 2 of 2
  1. #1
    duddu is offline Novice
    Windows 8 Access 2016
    Join Date
    Jun 2017
    Posts
    13

    Ms Access form

    I created a form marking guide and score for the call center.



    I have 12 questions and 10 agents to be scored and each question marking 5,10,15 % in drop down options when sum up all questions will get Total score % in one box. so based on those questions I need to show in the graph "Fail" when its come lower than 80% out of 100 like number of agents failed

    Please let me know how to show in a charts only Failed below 80%.

    Thank you!


    Sent from my iPhone using Tapatalk

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    There will be a field in the query record source with the total score, then in the criteria line say < 80%. Access handles percents in a strange way, so get the syntax right depending on how the fields are defined.

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

Similar Threads

  1. Replies: 3
    Last Post: 06-24-2017, 06:39 PM
  2. Replies: 3
    Last Post: 07-07-2014, 07:08 AM
  3. Replies: 1
    Last Post: 08-09-2013, 02:23 PM
  4. Replies: 1
    Last Post: 07-01-2013, 09:46 AM
  5. Replies: 6
    Last Post: 12-03-2012, 05:28 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