Showing results for 
Search instead for 
Do you mean 

Combining 2 fields into one.

New Member
Posts: 1
Country: United States

Combining 2 fields into one.

I have accidentally created 2 fields that should contain the same information.   1/2 of my records have the data in one field and 1/2 has it in the other.  How do I get that data into the same field for all of my records?


Thank you!

Bronze Contributor
Posts: 955
Country: Australia

Re: Combining 2 fields into one.



Once you decide which field you are going to keep do a lookup on the other field for records that contain data. This will give you a lookup then use the Edit, Swap or copy command to move the data to the right field

Paul Buchtmann Australia
Australia's First ACT Consultant (1989)

FREE Record History to change default to Call or To-Do for ACT! 2010-2012 versions. Custom versions also available.