cross reference 2 tables access Ben 14.07.2006 23:38:03 I have a project to take 2 tables in access and cross reference them manually. I figured let the computer do the work for me. I need to have access create a 3 table with duplicate employee names to show with their department names in subsequent fields. IE Names in field 1 Department names from table 1 in field 2 and Department names from table 2 in field 3. Then after that is all said and done i would like to make a query that shows the unmatched department names. Any help you can provide would be great. Thank you all.

Re: cross reference 2 tables access "Mike Revis" <mikeathazmatexpress.com> 14.07.2006 23:47:18 See access help for queries. "Ben" <Ben[ at ]discussions.microsoft.com> wrote in message news:E58C687E-FEBE-47E4-B72C-FE71A3F1679B[ at ]microsoft.com... [Quoted Text] > I have a project to take 2 tables in access and cross reference them > manually. I figured let the computer do the work for me. I need to have > access create a 3 table with duplicate employee names to show with their > department names in subsequent fields. IE Names in field 1 Department names > from table 1 in field 2 and Department names from table 2 in field 3. Then > after that is all said and done i would like to make a query that shows the > unmatched department names. Any help you can provide would be great. > > Thank you all.