How do I truncate (select) specific data in an Access query?

[Guest]

I am trying to truncate data in an access query so as to display only the
information that is relevant.

B12-R*20G Should be B12-R
B12-R*765 Should be B12-R
3DB30*967 Should be 3DB30

There is consistancy in the data, ie. the * and all data that comes after it
is irrevelant and needs to be removed in the display.

 

[Roger Carlson]

If you just want to DISPLAY the relevant data, you can do this:

NewField: Left([Field1],InStr([Field1],"*")-1)

If you want to change the field permanently, you can do an Update query:

UPDATE MyTable SET Field1 = Left([Field1],InStr([Field1],"*")-1);

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L