435,561 Members | 3,127 Online
Need help? Post your question and get tips & solutions from a community of 435,561 IT Pros & Developers. It's quick & easy.

# How to evaluate...

 P: n/a I'm new to Access and I am trying to get familiar, I have this line that seems to work just fine: Weight: IIf([Score_Rating]<=3,"Low","Medium") The Score_Rating is part of a query that does a Probability*RISK calculation. The Probability goes from a 1-5 and the RISK goes from 1-3. I need to have an evaluation that puts in the Weight field like this... 1-3 = LOW 4-8 = MEDIUM 9-15 = HIGH Any help with this would be greatly appreciated. Nov 13 '05 #1
4 Replies

 P: n/a "Xao" wrote in message news:2e**************************@posting.google.c om... I'm new to Access and I am trying to get familiar, I have this line that seems to work just fine: Weight: IIf([Score_Rating]<=3,"Low","Medium") The Score_Rating is part of a query that does a Probability*RISK calculation. The Probability goes from a 1-5 and the RISK goes from 1-3. I need to have an evaluation that puts in the Weight field like this... 1-3 = LOW 4-8 = MEDIUM 9-15 = HIGH IIf([Score_Rating]<=3, "LOW", IIf([Score_Rating]<=8, "MEDIUM", "HIGH")) -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com Nov 13 '05 #2

 P: n/a Try Weight: IIf([SR]<=3,"Low",IIf([SR]<=6,"Medium","High")) Note: Replace the SR with Score_Rating Jeff "Xao" wrote in message news:2e**************************@posting.google.c om... I'm new to Access and I am trying to get familiar, I have this line that seems to work just fine: Weight: IIf([Score_Rating]<=3,"Low","Medium") The Score_Rating is part of a query that does a Probability*RISK calculation. The Probability goes from a 1-5 and the RISK goes from 1-3. I need to have an evaluation that puts in the Weight field like this... 1-3 = LOW 4-8 = MEDIUM 9-15 = HIGH Any help with this would be greatly appreciated. Nov 13 '05 #3

 P: n/a Sorry Weight: IIf([SR]<=3,"Low",IIf([SR]<=8,"Medium","High")) "Jeff Smith" wrote in message news:ck**********@lust.ihug.co.nz... Try Weight: IIf([SR]<=3,"Low",IIf([SR]<=6,"Medium","High")) Note: Replace the SR with Score_Rating Jeff "Xao" wrote in message news:2e**************************@posting.google.c om... I'm new to Access and I am trying to get familiar, I have this line that seems to work just fine: Weight: IIf([Score_Rating]<=3,"Low","Medium") The Score_Rating is part of a query that does a Probability*RISK calculation. The Probability goes from a 1-5 and the RISK goes from 1-3. I need to have an evaluation that puts in the Weight field like this... 1-3 = LOW 4-8 = MEDIUM 9-15 = HIGH Any help with this would be greatly appreciated. Nov 13 '05 #4

 P: n/a "Xao" wrote in message news:2e**************************@posting.google.c om... I'm new to Access and I am trying to get familiar, I have this line that seems to work just fine: Weight: IIf([Score_Rating]<=3,"Low","Medium") The Score_Rating is part of a query that does a Probability*RISK calculation. The Probability goes from a 1-5 and the RISK goes from 1-3. I need to have an evaluation that puts in the Weight field like this... 1-3 = LOW 4-8 = MEDIUM 9-15 = HIGH Switch([Score_Rating]<4,"Low",[Score_Rating]<9,"Medium",[Score_Rating]<=15,"High") Nov 13 '05 #5

### This discussion thread is closed

Replies have been disabled for this discussion.