Search results
-
How do I Split My [Name] field into [FirstName] and [LastName] ?
I have 1 field that contains the names, ex: "John Brown", that field name is [Name], I want to split the [Name] field into 2 fields [FirstName] and [LastName]. How can I do this in an update query? I am not real sure how to use the update query as I have never had to before. Thanks in Advance ...