Syntax Error?

[BradBrad]

Hi All,

I've looked all over the internet.. What is wrong with my syntax?

iif ([Number of Years in Service]=<3&>1, "2 Weeks", iif ([Number of Years in Service]=<10&>3, "3 Weeks", iif ([Number of Years in Service]=<16&>10, "4 Weeks", iif ([Number of Years in Service]<26&>16, "5 Weeks", iif ([Number of Years in Service]>26, "6 Weeks", "Error")))))

Thanks!

 

[spikepl]

What is this supposed to be: <3&>1 ? If you are looking for x>1 and x<3 then this is exactly the way you need to write it.

& is a string concatenation operator

 

[BradBrad]

Alright, I'm getting some weird errors now:

33.29 gives me 2 weeks whereas 6.36 gives me 6 weeks.

iif ([Number of Years in Service]<="3"&[Number of Years in Service]>"1", "2 Weeks", iif ([Number of Years in Service]<="10"&[Number of Years in Service]>"3", "3 Weeks", iif ([Number of Years in Service]<="16"&[Number of Years in Service]>"10", "4 Weeks", iif ([Number of Years in Service]<"26"&[Number of Years in Service]>"16", "5 Weeks", iif ([Number of Years in Service]>"26", "6 Weeks", "Error")))))

Updated Code is above.

 

[John Big Booty]

I suspect that where you have used & you should simply be using the And operator. Be sure to leave a space either side of it

 

[BradBrad]

Alright, one number changed.. I'm still only getting 2 weeks and 6 weeks for numbers..

Any ideas?

iif ([Number of Years in Service]<="3" AND [Number of Years in Service]>"1", "2 Weeks", iif ([Number of Years in Service]<="10" AND [Number of Years in Service]>"3", "3 Weeks", iif ([Number of Years in Service]<="16" AND [Number of Years in Service]>"10", "4 Weeks", iif ([Number of Years in Service]<"26" AND [Number of Years in Service]>"16", "5 Weeks", iif ([Number of Years in Service]>"26", "6 Weeks", "Error")))))

 

[John Big Booty]

There is no need for your numbers to be enclosed in quotation marks .

iif ([Number of Years in Service]<= 3 AND [Number of Years in Service]> 1, "2 Weeks", iif ...

It is only text that needs that treatment.

 

[BradBrad]

Bah! It was the numbers in quotes.

Thanks a ton man! Have a great weekend!

 

[John Big Booty]

Glad you got it sorted