I have 10,000 records that were presented to me with the first and last name within a column in Access. For example: Smith, John<BR><BR>What is the best procedure to split these up within the Access column... Presently it resides in Name. I want to move last name to the LASTNAME column and first name to the FIRSTNAME column. <BR><BR>Copying and pasting won't suffice ;)<BR><BR>Thanks for the reply and hope all have a good day!