Extracting certain characters from text fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using Access 2000

I'm trying to merge portions of two text fields into one. I want the first
5 letters of one field (a last name) with the first 2 letters of a second
field (a last name).

For example if in one field I have the name Williams and in the other I have
the name Tom, I want the 3rd field to be willito. Please also I want the
final field to be a lower case where the original fields would have some
upper case characters.

I was hoping to use some kind of update query as I have hundreds of such
merges to do.

Thanks in advance for your help.
 
Back
Top