Removing Portions of Records

J

James O

Ok,

Quick Question. I have a Field filled with numbers of varying lenths. 8 or
more characters. If there are only 8 characters than I would want the record
left alone if there are 9 or more characters than I would want the left 8
charactoers deleted. How would I do this? Thanks!!

Hizaed
 
D

Douglas J. Steele

Permanently, or just in a query?

In a query, you'd put a calculated field along the lines of

NewField: IIf(Len([ExistingField] >=9, Mid([ExistingField], 9),
[ExistingField])

To do this permanently, you'd use the IIf expression above in an Update
query.
 
Top