Search results

Thanks guys, that seems to have made the difference. Now here is another question: I'm wanting to use this query to Update the existing table using the Update Query, but it keeps asking me for atleast 1 destination field. I know what field I want it to update to but I guess I don't know the...

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 ...