Question IF en Then functie

[Jingels]

Hello,

i have number fields in a table (1-6),
1. HeelonLeashandFig_8 40 points
2. StandforExamination 30 points
3. HeelFree 40 points
4. Recall 30 points
5. LongSit 30 points
6. LongDown 30 points
7. Total score (1+2+3+4+5+6=)
8. qualifying

now i want that field [qualifying] will be filled in with "Q". if fields 1-6 have each 50% of there points and a toal score of 170 and more.

How can i do that

I have been using the following code but it won't work.

qualifying: IIf([Score]>194;"XQ";IIf([Score]>169;"Q"))

thanks a lot

 

[Ranman256]

Use a SWITCH statement.

 

[Jingels]

oke, the switch statement. My question is a little bit different.
All of the fields have to be above 50% and a total of 170 >. And then you get a Q. if one of the scores is less than 50% there is no Q

 

[Ranman256]

You only have 2 options out of 3.
The option for Numbers < 170 are not provided

 

[Jingels]

i don't understand that.

 

[Ranman256]

Just lookup SWITCH.