I agree with Gunny that you may need to ensure the [Code 5 Digits] is

evaluated as a number and you could use Val([Code 5 Digits]) or

CInt([Code 5 Digits]) to do this.

You could use Switch to look at another range of numbers by adding

more arguments. Like this:

Switch(

[Code 5 Digits]>=10121 And [Code 5 Digits]<=10135,[Code 5

Digits]&"xxx",

[Code 5 Digits]>10135,"is larger",

[Code 5 Digits]<10121,"is smaller")

Just make sure the ranges used do not overlap <grin>

Nancy

On 31 Dec 2006 12:16:44 -0800, "jg******@bellsouth.net"

<jg******@bellsouth.netwrote:

>All,

I have the following expression in a query:

Switch([Code 5 Digits]>=10121 And [Code 5 Digits]<=10135,[Code 5

Digits]&"xxx")

(There are other expresions within Switch, but this is the one in

question.)

I need to evaluate [Code 5 Digits] as a number, but then concatenate

with the text "xxx" if it meets the conditions.

Thanks.

JG Scott