Trim Field

Pete · Sep 3, 2003

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 · Sep 3, 2003

Pete

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

Good luck

Jeff Boyce
<Access MVP>