Unanswered: making one field two feilds (First Name Last Name)
I have a couple of feilds (Full name and Zip code) I would like to seperate into seperate feilds. The Full name feild I would like to split into two fields by the space. I would like to split the Zip code into the two fields the first 5 digits, and the last four by the -. This is my first posting so forgive me any transgressions.
First off, Thank you i had no idea what kind of responce time to expect. This is amazing. I have read through some of the history. Forgive my naive on this matter. My experince with access is mostly on the data quering for sales reports and merge purge for mailings.
I will be doing this on the table level, i guess. Would i do this through a query, like an update query?
Would this be how i would apply that
Where [zip] is like "*-*" set [zip5] to Left(zip, 5) .
THe feild name that has the zip plus 4 is zip and i would like the first 5 in the zip to be in the zip5 feild.