I'm an excel user and in using excel I can take two fields and combine their data in one field. I've got about 6 database files with anywhere form 1000 to 3000 records that have already been prepared and imported into access database files .mdb and I realize that the firstname lastname fields need to also be combined into a contact field with both names. In Excel it's easy in access I'm a little lost. I was looking to an update query however I can't find instructions on what I'm trying to do.
I wasn't sure how to search for this and my searches came up with very little. I may just be lost on what to search for so if someone can point me in the right direction, that would be great also!
Any help would be appreciated as you guys always have great solutions.
Thanks
Keith