Separating data into 2-fields?

[djclntn]

I know how you can take 2-pieces of data from 2-fields & combined them into 1-field. E.g. if you have a ‘First Name’ field & ‘Last Name’ field you can join them together into 1-field. However, what if I have a field with both the first & last name in one field but I want to separate the names into 2-fields; a ‘first’ & ‘last’ name field/ can it be done & how involve may it entail?

Thanks

[June7]

The value has only first and last name parts - no middle initial, no suffix (Jr, Sr, II, III, PhD)? There is always a space between the two parts?

Use string manipulation functions. http://www.techonthenet.com/access/functions/

Left(fieldname, InStr(fieldname," ")-1)

Mid(fieldname, InStr(fieldname," ")+1)

[djclntn]

Thanks June!

I'm posting another in 'Forms'