Results 1 to 7 of 7
  1. #1
    Join Date
    May 2008
    Posts
    6

    Unanswered: Help with IIF, "Enter Parameter Value"

    Thank you to anyone that can help me out on this!

    Total noob at access and happend to have a project land in my lap

    So anyhow I have a QA form for a Call Center, it has a list of fields with three options.

    Met
    Needs Work
    Does Not Apply

    I need to create a formula that will pull out the data from the fields and create a score for the QA. The formula is Total Met / Total Needs Work = Score % I do not want the fields with "Dose Not Apply" to effect the score.

    I hope this is enough info, I have added in a document that might help show you what I am trying to do.

    Access Question.doc
    Last edited by vapid2323; 05-21-08 at 18:51. Reason: Needed better title

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Use expressions in the query where you convert the Met and Needs Work fields to values (1 or 0). If these fields are true or false, you'd have an expression like: TotMet: iif([met] = True,1,0). Same for Needs Work.

    This will give you the initial query by which you can use another query (or report) based on the first query and sum the values from that query and do your final equation (or sum the values in the report footer).

    If Met and Needs Work are not true/false fields, then you need to construct the expression to do the same thing (ie. iif([Met]="Y",1,0).
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    May 2008
    Posts
    6
    ok,

    So I have been trying to get this to work for about 3 hours since I got in to work, I still need help

    This time I am going to add in a copy of my data so that you can just see what I am trying to do.

    I know that this must be a simple issue and belive me I have been going on google every step of the way lol, I think the problem is that I dont know where to put the inital query. I have put it in a new query but it keeps asking me to "Enter Parameter Value".

    iif([Met]="Y",1,0)

    What am I missing?

    Call Monitor Form.zip

  4. #4
    Join Date
    May 2008
    Posts
    6
    SQL if helpfull

    SELECT [Call Monitor Form].ID, [Call Monitor Form].[Answer call on 1st ring], [Call Monitor Form].[Thank them for choosing Wave/ Astound (intro &closing)], [Call Monitor Form].[Verify caller is authorized], [Call Monitor Form].[Establish rapport with the customer], [Call Monitor Form].[Demonstrate active listening], [Call Monitor Form].[Keep customer informed (avoid/explain dead air)], [Call Monitor Form].[Avoid / Explain Jargon], [Call Monitor Form].[Accurate assessment of customers needs], [Call Monitor Form].[Demonstrate technical knowledge], [Call Monitor Form].[Utilize tools and resources], [Call Monitor Form].[Took appropriate steps to resolve call], [Call Monitor Form].[Maintain control of the call], [Call Monitor Form].[Took Ownership of call], [Call Monitor Form].[Resolve reason for the call OR gave time line for follow up], [Call Monitor Form].[Clearly note the Billing and Wipeout systems], [Call Monitor Form].[Correctly complete all necessary steps; tickets], [Call Monitor Form].[Close call appropriately], [Call Monitor Form].[Correctly transfer call (warm -vs- cold)], IIf([Met]="Y",1,0) AS TotMet
    FROM [Call Monitor Form];

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    IIf([Met]="Y",1,0) AS TotMet
    No. With your structure you would need

    IIf([Answer call on 1st ring]="Met", 1, 0) as ACO1RMetTally
    and
    IIf([Answer call on 1st ring]="Needs Work", 1, 0) as ACO1RNWTally

    in a query, same for every other field.

    Then you can add up all the Tally fields to get totals for each field.

    Then you'd need to add up all the totals for met and the totals for needs work and finally do the division for the score.

    Nice long and confusing job for a total noob at Access to take on ^^

    Good luck!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    May 2008
    Posts
    6
    YOU ROCK!!!

    That did it, kinda a pain in the ass but ohh well it works lol
    Last edited by vapid2323; 05-22-08 at 19:20.

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049

    Cool I rock!

    Glad to see that you've cracked it
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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