Minus Right?

[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

 

[Ken Snell \(MVP\)]

FirstNums: Left([FieldName], Len([FieldName]) - 3)

 

[Wendy]

Thanks Ken. Thats does exactly what I needed.

Wendy

FirstNums: Left([FieldName], Len([FieldName]) - 3)

--

Ken Snell
<MS ACCESS MVP>

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