Sample Header Ad - 728x90

How can I Use Access to combine tables of information

0 votes
1 answer
98 views
I have two tables in access with a common ID number in both. One table has mail to info and the other table has account information. The account information can have multiple listings per ID. The mail to info has one listing per ID. I need to combine the two tables to create a new table with 1 row per ID but containing multiple columns with the added account information. How do I do that?
Asked by Summer Gould (1 rep)
Nov 3, 2014, 11:50 PM
Last activity: Dec 17, 2021, 11:01 AM