Minus Right?

W

Wendy

Hi

I have a query which has a 4 or 5 numeric code in it and I need to split the
first one or two numbers. Thats my problem I never know whether there will
be one or two numbers I've tried SolLoc: Right([solct],-3) but that doesnt
work.
It will always have 3 numbers after the ones I need to move which I put into
a different field SolCode: Right([solct],3) which works fine.

Thanks

Wendy
 
W

Wendy

Thanks Ken. Thats does exactly what I needed.

Wendy

Ken Snell (MVP) said:
FirstNums: Left([FieldName], Len([FieldName]) - 3)

--

Ken Snell
<MS ACCESS MVP>

Wendy said:
Hi

I have a query which has a 4 or 5 numeric code in it and I need to split
the
first one or two numbers. Thats my problem I never know whether there
will
be one or two numbers I've tried SolLoc: Right([solct],-3) but that
doesnt
work.
It will always have 3 numbers after the ones I need to move which I put
into
a different field SolCode: Right([solct],3) which works fine.

Thanks

Wendy
Click to expand...
Click to expand...
 
Top