Hello,I have table where last name, first name and middle initial are in one column and I would like to split in three, here is sample how it is now. Person_Name = Smith, John Mand I would like to see this wayFirst_Name = JohnLast_Name = SmithMiddle_Initial = MPlease help thanks

Hello hhh1027,My suggestion is likely not the easiest way, and does not involve a query - an expert in this community will likely offer a better way to do this.You can:1) Export the table to Excel2) Insert a few extra columns behind the Person_Name column3) Highlight Person_Name column4) Choose Data ---> Text to Columns ---> Delimited ---> Space5) Rename your newly created columns, First_Name, Last_Name, Middle_Initial6) Delete any extra commas using find/replace 7) Import back into AccessThere are also some previous posts here that are similar to your goal. Here is an example:http://www.utteraccess.com/forums/showflat...;Number=1909090Hope this helps,-Kristoph

The answer for your question I think would be a User Defined Function that would have to handle the logic taking into account the names with/without a middle initial (and possibly any out of the ordinary names) that you could then use in an update query

HiIf you're using my example (which doesn't take into account names without middle initials) then it is an update query already. Copy and paste it into the SQL view of a new query and change the names I've used to your actual names.CAUTION - try it on a back up of your data first, but again, it doesn't take into account names without middle initials or names like Mark De Sylva or Ian St. John. You'd have to write a UDF to handle all of the logic for that