Community
Showing results for 
Search instead for 
Do you mean 
Reply

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.

JHill,

 

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
pbuchtmann@ozemail.com.au 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.