Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 08-06-2009
Member
 
Join Date: Jan 2009
Posts: 91
How to combine two field in access

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..!
Reply With Quote
  #2  
Old 08-06-2009
Member
 
Join Date: May 2008
Posts: 4,565
Re: How to combine two field in access

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 :
Code:
UPDATE YourTable  
  
SET YourNewField = SkillID & ApplicantID;
Reply With Quote
  #3  
Old 08-06-2009
Member
 
Join Date: Jan 2009
Posts: 91
Re: How to combine two field in access

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?
Reply With Quote
  #4  
Old 08-06-2009
Member
 
Join Date: May 2008
Posts: 4,829
Re: How to combine two field in access

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...
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to combine two field in access"
Thread Thread Starter Forum Replies Last Post
In Access 2007 I need to combine multiple tables into 1 having identical fields djbbenn Software Development 4 09-05-2012 09:21 PM
Use Of Auto Increment field In Access database Pony Software Development 5 03-02-2011 10:24 PM
Field properties in Ms Access 2007 Bansi_WADIA Windows Software 5 08-01-2010 05:10 AM
Multi Field value field in Microsoft Access Erubiel Windows Software 3 20-11-2009 12:55 AM
To access a text field from another form Sanket07 Software Development 6 06-02-2009 06:42 PM


All times are GMT +5.5. The time now is 08:45 AM.