Hi,

You can download a list of the states and their abbreviations from

http://www.usps.com/ncsc/lookups/usp...eviations.html

If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Terry Berry" wrote:

I have a database that includes states and district numbers in separate
fields. I need to take those 2 fields and change them to a third combined
listing.
For Example:

Tennessee 5 and change to TN_05
Arkansas 2 and change to AR_02

I will eventually have over 3000 entries and any help would be greatly
appreciated