Trim Field

P

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
 
J

Jeff Boyce

Pete

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

Good luck

Jeff Boyce
<Access MVP>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trim a field down 2
type mismatch error in macro in excel 0
Need help with IIf and Trim$ function in a query 6
trim in query 6
adding empty spaces to fields? 10
How to have two tables on same line? 1
Trim a word from a field 3
Space at end of multi page list to accommodate new entries 1

Top