How to combine two field in access

[X-Man]

I have a table in ms access with some values in two fields. I want to combine the existing two fields. Is there a way to perform such thing? Please help guys, i'm in desperate needs... Thanks in advance..!

[Glenny]

You must first create a third field, where you can put/save/store the combined value. Now to set the value for the third field you must do the update query. Once done this you may perform the action for deletion of the two fields. If this is what you are looking for you can do this by :

UPDATE YourTable  
  
SET YourNewField = SkillID & ApplicantID;

[X-Man]

But then won't it break all the rules about the primary key field? One field should contain atleast one piece of data... I'm just not sure about this method...! What are your thoughts? Will this work?

[Macarenas]

Well that really depends on what you are trying to do. If you want to keep the original fields, then you are absolutely right. However, if you don't need the two fields are the value is combined of those 2 fields into one Primary key, there is no problem with it...