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?

  • Why you want to combine both the table in one table? – vijayp Nov 4 '14 at 4:15
  • Because I need all the information to merge into a letter that is being sent to the business on the mail info table. – Summer Gould Nov 4 '14 at 15:38
  • You can write sql query using join too get the desired result – vijayp Nov 5 '14 at 6:39

Use the query wizard to create a new "temporary" table - a 'view' (a query). This you can use then as source for your letter.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.