Access IF statement scoring

[craigmase]

I am building an audit tool where the answer to each question is either
Incorrect or Correct
or
Incorrect, Correct, Feedback
I want to add a score to each answer given (will be different per question due to weighting)
Ultimately it will give a score out of 100
I have this presently built into Excel easily, but Access not so much

The form is built, questions etc all in but just needs the coding etc
someone please help

 

[Joe4]

Tell us exactly how you have it working in Excel (formulas, etc), and we'll probably be able to help you.

 

[craigmase]

well the first question is
=IF($M$13="correct", 12, 0) This one has two options of "correct" or "incorrect"
=IF($M$14="incorrect",0,IF($M$14="Correct",6,IF($M$14="N/A",6,0))) this one has "NA" too which scores positively
=IF($M$20="Correct",6,IF($M$20="Incorrect",0,IF($M$20="Feedback",3,IF($M$20="N/A",6,0)))) this one has "feedback" too which scores but lower

 

[Joe4]

Access has an equivalent to the IF function, it is the Immediate IF function (IIF).
So, your first formula would look something like this:

=IIF([FieldName]="correct",12,0)

So as you can see, it is remarkably similar.
Likewise, you can nest them, just like you do in Excel.

Armed with that knowledge, see if you are able to get it to work for you.