Community
Showing results for 
Search instead for 
Do you mean 
Reply

Easier way to populate a new field?

Accepted Solution Solved
New Member
Posts: 1
Country: USA
Accepted Solution

Easier way to populate a new field?

We have a database that's about 17K records, and we're adding a new field into it.  We want the new field to have a value "0" in it for all the records.  Future records will be blank and have a value that will be entered in by the user.

 

What's the easiest way to populate that value into the new field for the existing records?  Should I extract the whole database into something like Excel, populate it the value, then re-import the database?

 

I think there might be an easier way than this, but I'm just not sure.

 

I'm using ACT 2008 V10

 

Thanks.


Accepted Solutions
Solution
Accepted by topic author rsol
‎09-25-2015 03:20 AM
Silver Super Contributor
Posts: 2,328
Country: USA

Re: Easier way to populate a new field?

Add the field to the database and then do an Edit | Replace from the menu.

 

Stan


If you would like to get more out of ACT! you can find an ACT! Certified Consultant near you by going to:www.act.com/acc.
-------------------------------------------------------------------------------------
Stan Smith
ACT! Certified Consultant
ADS Programming Services, Inc.
(205) 222-1661
www.adsprogramming.com
www.actwebhosting.com
Click Here to Purchase Act!

View solution in original post


All Replies
Solution
Accepted by topic author rsol
‎09-25-2015 03:20 AM
Silver Super Contributor
Posts: 2,328
Country: USA

Re: Easier way to populate a new field?

Add the field to the database and then do an Edit | Replace from the menu.

 

Stan


If you would like to get more out of ACT! you can find an ACT! Certified Consultant near you by going to:www.act.com/acc.
-------------------------------------------------------------------------------------
Stan Smith
ACT! Certified Consultant
ADS Programming Services, Inc.
(205) 222-1661
www.adsprogramming.com
www.actwebhosting.com
Click Here to Purchase Act!