Steve Goodhall
steve at goodhall.info
Tue Jan 1 16:03:47 CST 2013
There is a Federal standard for county codes. Look at http://en.wikipedia.org/wiki/FIPS_county_code I believe that this (http://www.stssamples.com/xls/US_FIPS_CountyCodes_092309.xls) link will give you a complete table. Steve Goodhall -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kathryn Bassett Sent: Tuesday, January 01, 2013 4:51 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] State/County table? I'm trying to build an mdb that will have states and counties. Anyone have a table, or know how to get one that I can import that has all the states and their counties? This is going to be for a marriage index, and I want to have the main table do a lookup for the state/county so I can have a dropdown box in the form. -- Kathryn Rhinehart Bassett (Pasadena CA) "Genealogy is my bag" "GH is my soap" kathryn at bassett.net http://bassett.net -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com