Trim Field

[Pete]

Hi,

Can anyone tell me how I can run a query that trims the last 6 characters
returned in a field. The field contents is of variable length, however I
need to trim the ending to match data in another table.

Many Thanks
Pete

 

[Jeff Boyce]

Pete

Take a look at the Right() function (and Left(), Mid()).

Good luck

Jeff Boyce
<Access MVP>