Expressions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pompey_Boy - 13 Sep 2005 11:24 GMT

Hi can anyone help with this:

I'm trying to use an IIf Between and And statement to work out
curriculum levels ie if between 1 and 4 then show '3c' if between 5
and 8 then show '3b' and so on, I've got the first bit working ok, but
if I then and a '+ IIf'and do the next one, I get an error.

Reply to this Message

Graham R Seach - 13 Sep 2005 12:11 GMT

You can use the IIf(), Choose(), or Switch() functions:

IIf(intNumber >=1 And intNumber <=4, "3c",IIf(intNumber >=5 And intNumber
<=8, "3b", "3a"))

Choose(intNumber,"3c","3c","3c","3c","3b","3b","3b","3b","3a")

Switch(intNumber >=1 And intNumber <=4, "3c",intNumber >=5 And intNumber
<=8, "3b", intNumber >=9, "3a")

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

> Hi can anyone help with this:
>
> I'm trying to use an IIf Between and And statement to work out
> curriculum levels ie if between 1 and 4 then show '3c' if between 5
> and 8 then show '3b' and so on, I've got the first bit working ok, but
> if I then and a '+ IIf'and do the next one, I get an error.

Reply to this Message

Gijs Beukenoot - 13 Sep 2005 12:12 GMT

From Pompey_Boy :

Is this wat you mean?
IIF( <currilcumValue> between 1 and 4, "3c", IIF( <curriculumValue>
between 5 and 8, "3b", <FalseValueOrFunction>))

Reply to this Message