Splitting data in an Access data field
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.
Change the world. Of one person. Today.
If your equation requires either a complex combination of variables to get the desired result OR you can't seem to get the result regardless of the variables....it ain't your variables, it's your constant.