Yes/No Field Checkbox impacting expression

[elizamcbeth]

Forgive me, I'm a self taught database designer. I'm novice and my terminology is off. I'm a Quality and Training Manager of a call center. My database was designed to house the scores of the calls that are being monitored for quality purposes. I created it and got it up and running, and now I need to make a change that I have no clue how to do or what to search by asking the right question to learn how. PLEASE HELP!

My main table contains records of all of the calls. When an account is not verified by the CSR, I need to indicate if it was properly verified (ideally with a yes/no box). If yes, the score of the call would remain the same. If no, the score of the call would automatically decrease 10%. The score is a calculated field on the query and form. How can I get the yes/no box to drive the score down (or remain the same)? I added the checkbox to my table, query and form... but I don't know how to add the function it needs to deliver.

Any help is much appreciated!

[orange]

I'm going to suggest you work through this tutorial. You will see how you can go from a description of "your business" to a set of tables and relationships representing a data base that supports you business. You will learn a lot from this tutorial and will be able to apply it to your situation.

And the forum is still here to answer questions.
Good luck

[June7]

Something like:

score * IIf([checkboxfield]=False, 0.9, 1)

[NTC]

the 10% decrease is a calculation so you don't need to record that but rather put that calculation in place where data is displayed (typically the query which will be the record source of the form/report). the benefit of not storing it is that when an error is made one can just change the check mark without having to remember to change the score..... one would assume you have a 'preVerificationScore' so it would look something like: FinalScore: IIf([checkboxfield] <>-1, 0.9*[preVerificationScore], [preVerificationScore])

[elizamcbeth]

Ok I'm getting closer. Hooray! The score is now resulting in a 0% when the account verification. However, I can't seem to figure out the correct calculation to make the score decrease 10% when unauthorized callers is missed. It makes the entire score 10%. What am I missing here? Please help.

Score: IIf([tblAccountVerification]=0,0,IIf([tblUnauthorizedCallers]=0,0.1,[ActualPts]/[PossiblePts]))

[June7]

There is nothing in that expression to decrease anything. Not applying either of the suggestions given in previous posts.

tbl is prefix for a textbox? Most developers would use that as prefix for table name.