-
1. Re: Moving content from one field to another
Use Replace Field Contents to copy the contents of Postal Code into the Zip Code field
Save a back up of your DB file in case you make a mistake.
Do a show all records or perform a find to pull up the records where you need this update as this tool modifies all records in your current found set
Click into the zipcode field.
Select Replace Field contents from the Records menu (NOT the edit menu) and use the calculation option to specify the postal code field as the source of the data you want to copy into the zip code field.
-
2. Re: Moving content from one field to another
Brilliant Phil!
And just to confirm, if I want to search for all records with a Postal Code but not a Zip Code I would search for;
Postal Code = "*" (to show not empty) and Zip Code = "=" (to show empty)
Does that sound right?
-
-
4. Re: Moving content from one field to another
Thank you Phil! You're always the best and fastest to answer!