need to delete the first 4 numbers of each record

J

Jimmy

I have 45000 records. In one field about 80% of those records are in a
format: 4numbers space and a word (any word). What I need is to delete
those 4 first numbers in every record that begins with 4 numbers. Is it
possible? Can someone help?
Thank You
Jimmy
 
C

Cheryl Fischer

You could use the IsNumeric() function to determine whether the first 4
characters in your field evaluate to a number, as in the following untested
example:

IIf(IsNumeric(Left([MyField], 4)), Mid([MyField, 6), [MyField])

Insert the above expression into the Field: row of a Select Query to test
it out. If you like it, then use the expression in the Update to: row of
an Update Query.
 
Top