Trimming in a query

[ddoblank]

Is there any way to trim a field that has different lengths?
Eamples
56Z8001001
56Z801001
56Z81001
I want to get rid of only the 001 on the right side of each item. I have
tried everything I know expect setting up multiple queries for each type and
then pasting.
Thanks, Darren

 

[Al Campagna]

ddoblank,
As long as it's always the 3 characters on the right...
= Left([Field], Len([Field])-3)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Wayne-I-M]

Left([TableName]![FieldName],Len([TableName]![FieldName])-3)

 

[ddoblank]

That works perfectly. Thank you both for your help.
Darren

ddoblank,
As long as it's always the 3 characters on the right...
= Left([Field], Len([Field])-3)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

Is there any way to trim a field that has different lengths?
Eamples
56Z8001001
56Z801001
56Z81001
I want to get rid of only the 001 on the right side of each item. I have
tried everything I know expect setting up multiple queries for each type
and
then pasting.
Thanks, Darren