How to remove leading characters in a text field?

V

VictorJB

If have a database that is created by importing a delimited text file.
Some of the text fields in the text file are padded out by using leading
zeros.
Once I have the data in an Access table, how can I strip the leading zeros
away to leave me with the data I actually need?
 
K

Ken Snell [MVP]

Use the Val function in an update query to easily do this:

UPDATE TableName
SET TextFieldName = CStr(Val([TextFieldName]);
 
Top