R R. Choate Feb 27, 2009 #1 Is there a formula or code snippet which will convert the occasional long state name to the 2-character code? I've got a real mess to clean up Thanks!
Is there a formula or code snippet which will convert the occasional long state name to the 2-character code? I've got a real mess to clean up Thanks!
J John Mishefske Feb 27, 2009 #2 R. Choate said: Is there a formula or code snippet which will convert the occasional long state name to the 2-character code? I've got a real mess to clean up Click to expand... No. I'd suggest you create a new table with state name and abbreviations (source: http://www.usps.com/ncsc/lookups/abbr_state.txt) and do an update query. -- John Mishefske, Microsoft MVP 2007 - 2009 UtterAccess Editor Tigeronomy Software web: http://www.tigeronomy.com email: sales ~at~ tigeronomy.com
R. Choate said: Is there a formula or code snippet which will convert the occasional long state name to the 2-character code? I've got a real mess to clean up Click to expand... No. I'd suggest you create a new table with state name and abbreviations (source: http://www.usps.com/ncsc/lookups/abbr_state.txt) and do an update query. -- John Mishefske, Microsoft MVP 2007 - 2009 UtterAccess Editor Tigeronomy Software web: http://www.tigeronomy.com email: sales ~at~ tigeronomy.com
