Changing data in a table 1

[fmaca]

Good morning.

I have some infomation in a table that looks like this: E8FZ-AA.

Some of the data has been entered in incorrectly and has a number in the last series of characters like E8FZ-A1A.

Is there an easy way I can strip the numbers out of the part of the information after the -?

Thanks in advance.

Ethan

 

[TonyJollans]

Hi Ethan,

If all the data are in exactly the format you show then this will do it (put it in an Update Query or run it in VBA):

UPDATE TableName SET TableName.FieldName = Left([FieldName],6) & Right([FieldName],1);


If the formats are variable it will get more complicated but can still be done.

Enjoy,
Tony