Strip - Data that is!

[Gunit]

I am pretty new at Access and would like to know how I can strip the last 3 alphanumeric char in a field. Easiest way preferred. Thanks!

I.E.

51-0054.01
51-0054.02
51-0054.03

 

[sfreeman@co.mer]

If the field is fixed width at 10 characters, try this...

create an update query to update the field in question [here labelled Field1]

UPDATE tblOne SET tblOne.Field1 = Left([field1],7);

HTH

 

[Gunit]

Thanks! So easy!