Update Query

[rjf3123]

Tying to update a field in a table to contain only the first n characters of another field in the same table.

eg. [master].[field1] Text - contains up to 150 characters
[master].[field2] Text - can only contain 24 characters

Want to update field2 to the first 24 characters from field1

Tried a few things with an update query that ended up messing up the table (good thing I made a copy first!)

TIA -
R. Fisher

 

[llkhoutx]

Take a look at the Left function, that's what you need.