Using Access 2003 Trying to join the following two tables: TABLE 1- this is a reference table that lists census block groups and associated zip codes within a geographic region. For every censusblocknum there is one zipcode. For every zipcode there is one or more censusblocknum. FIELD 1 (text) FIELD 2 (text) censusblocknum zipcode
TABLE 2- this is a data table that lists census blocks that meet a certain criteria accompanied by a value. FIELD 1 (text) FIELD 2 (text) FIELD 3 (number) censusblocknumA censusblocknumB numcommutes RESULT DESIRED-assignment of the correct zipcode (from table 1) to the rows in each of the two censusblocknum columns of table 2: censusblocknumA zipcodeA censusblocknumB zipcodeB numcommutes Thanks for your help
