Create a New Field
Set the Type to Text
Then in the New Field Options, Under the 'Auto-Enter' Tab, Select Calculated Value.
In the 'Specify Calculation' window, select the fields you want combine. which, according to the example you provided, would be: City & State & Zip
(That will render: CityStateZip as a joined text string)
Once your Calculation is complete, hit OK and you will be back at the Options window for your new field.
**Be Sure to Check the Box for 'Do Not Replace Existing Value of Field'
This will populate the new field with your desired joining of the three fields and will maintain the calucated result upon deletion of the original 3 fields.
use a calculation field, the & operator will join the text values together.
=City & State & Zip
Having got your new field with CityStateZip (check in brows mode to make shure it has done what you want)
You can change the field type from calculation to text and then delete the other 3 fields.
I personally like to keep those types of fields seperate in the table and use the calculated field to show on the layout. That way when I need to search for a zip etc it is easy.
You can add & "¶" & between each field this will add a carriage return between each field which also aids searching.
=City &"¶" & State &"¶" & Zip would produce a field with
I would only delete the first three fields when I was sure I wouldn't need them.
Thanks to both of you, both good solutions and good info. I wasn't sure how to "save" the data.... worked GREAT THX