By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,561 Members | 3,127 Online
Bytes IT Community
+ Ask a Question
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
Xao
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
Share this Question
Share on Google+
4 Replies


P: n/a
"Xao" <te@ivorypetal.com> 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" <te@ivorypetal.com> 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" <No***@Not.This.Address> 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" <te@ivorypetal.com> 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" <te@ivorypetal.com> 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.