Trim

[CVegas]

Please advise syntax to trim all but the first 3 letters that are in a
field.

Field Name:[City]
Field Value: BOS Boston, MA
I want to retain the value BOS and delete Boston, MA

TIA

 

[Van T. Dinh]

Left([City], 3)

See Access VB Help on Left() function.

 

[fredg]

Please advise syntax to trim all but the first 3 letters that are in a
field.

Field Name:[City]
Field Value: BOS Boston, MA
I want to retain the value BOS and delete Boston, MA

TIA

=Left([City],3)

 

[Naresh Nichani MVP]

You could type a query like this in SQL window : -

Update [YourTableName] Set [City] = Left([City],3)

Save query and execute and it should do for all records.

Regards,

Naresh Nichani
Microsoft Access MVP