Newbies cr3ation Posted February 18, 2005 Newbies Share Posted February 18, 2005 Please forgive my igorance. I'm still teaching myself. I'm taking an old mailing list and trying to integrate it with a new one. The new list has a "FirstName" field but the old one doesn't, however the old one DOES have a "Saluation" field containing the info I need to copy. I tried to define a calculation for the "FirstName" field: FirstName= Salutation But this only seems to work when I'm entering in new records. How can I make it go through the existing records and fill in this new field? Any ideas? Link to comment Share on other sites More sharing options...
-Queue- Posted February 18, 2005 Share Posted February 18, 2005 Find all records, put your cursor in a non-calculation field on your layout, select Records -> Replace Field Contents, 'replace with calculated result', and type the name of the currently selected field into the calculation. Click OK, then Replace. This will force existing records with a blank FirstName field to update using the auto-enter calc. Link to comment Share on other sites More sharing options...
Leader Posted February 20, 2005 Share Posted February 20, 2005 Sheesh, Q, good one. It's so easy to forget the simple solutions. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7005 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now