Hi
I have a table called keywords which has a field called competition. Competition can range from 0.01 - .99.
I would like to replace the text of an additional field called competitionexplanation, with the following:
if <= .3 text in competition explanation should state "low"
if >= .4 and <= .6, text in competition explanation should state "med"
if >.7 text in competition explanation should state "high"

I have tried different ways but am getting nowhere. If you could help it would really be appreciated,
best wishes
Sam
 

---

Answer from Richard Rost:

You could create a calculated query field to do this using an IIF function. It would be something like:

MyValue: IIF(X<=.3,"low",IIF(X<=.6,"med","high"))

Notice I've got TWO nested IIF functions in there. Here are two tutorials that will help you with these concepts. Watch them in order:

http://599cd.com/tips/access/calculated-query-fields?key=BlFAlEx

http://599cd.com/tips/access/iif-function?key=BlFAlEx