I am using Access 2016.
I would like to create a new field based on an existing field.
The current field is the abbreviation for Canadian provinces. The new field will be the full province name.
Example Field 2 = ON. The new field would be Ontario.
I have approx. 875,000 records
Thanks for your help
Chomp