Splitting data in an Access data field

Status
Not open for further replies.

superdave1984

Repeat Offender
Messages
1,986
Location
KY
Is this possible? I have a simple Access database. One of the data fields is the name. It is entered as Last, First in the box. Is there a way to split this data to make it easier to search the database? Here's a pic of the database.
And manually creating a new field will be impractical as there are 25,000+ records in this dataabse. Unless this can be split somehow and the new field created then.
 

Attachments

  • db.JPG
    db.JPG
    61.8 KB · Views: 11
Status
Not open for further replies.
Back
Top Bottom