Ignore and trim code 1

[lars7]

Hi Guys,
Can anyone help me with this one,

I have a field called pay scale which is a 4 digit code.

What I would like is for the code to only shows if it starts with a number, the letters to be blank, and also I only want the first 3 digits to show

hope this makes sense

Sample of pay scale:

Pay Scale
W116
202N
304C
R05D
205D
206E
207D
208D
D022
W123
C770

Thanks in advance.

 

[GingerR]

Look up functions:

Left
IsNumeric

Try some things out and let us know how it goes.


Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[lars7]

Hi Ginger,

Thanks for the "isNumeric" that's what I was missing:

Expr1: IIf(IsNumeric(Left([pay scale],1)),(Left([Pay Scale],3)))