Switch Function

[Tempest]

Hi All,

Some help from cyber space is what I need me thinks , I am using a switch function in an access query to convert 24 to 624 and 28 to 628 and so on for about 5 entires however there are numerous entries that might not meet my criteria that are errorrs can I just simply place in there a default option if the rest are not made like in a case statement.

I know somebody is going to suggestion placing this in a macor/function but would prefer to not have to do that if possible, but if I do I dot.

Any help greatly appreciated. Come on Cyber Space dont let me down!

Cheers,
Tempest
"Life is like a box of choclates you never know what your gonna get"

 

[Jon K]

Try something like the following:

Switch([Num]=24,624, [Num]=26,626, [Num]=28,628, 111,999) +0


111 - an unlikely number in [Num]
999 - a default value
+0 - converts returned values to numeric
.