# Thread: Need to total up fields to create a % based score

1. Registered User
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. Moderator
Join Date
Dec 2004
Location
Posts
3,928
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).

3. Registered User
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. Registered User
Join Date
May 2008
Posts
6

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. L33t Helpa Munky
Join Date
Nov 2007
Location
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!

6. Registered User
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. L33t Helpa Munky
Join Date
Nov 2007
Location
Posts
4,049

## I rock!

Glad to see that you've cracked it

#### Posting Permissions

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