Ms-access – How to Use Access to combine tables of information

ms-access-2010

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?

Best Answer

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

Related Solutions

Ms-access – Access Value between ranges

Try something along the lines of:

UPDATE Table2 
INNER JOIN Table1 ON Table2.[My Values] >= Table1.Start AND Table2.[My Values] < Table1.End
SET Table2.Bucket = Table1.Bucket;

Essentially, we get the value from Table1 by comparing the My Values field in Table2 to see if it is between Table1.Start and Table1.End

This will update the entire Table2 in a single statement, and shows the power of set-based approaches to data vs what is referred to as "row by agonizing row" or RBAR. See https://www.simple-talk.com/sql/t-sql-programming/rbar--row-by-agonizing-row/ for a great explanation of that.

Ms-access – Access 2010 After Insert data macro to update another table

An "After Insert" data macro can certainly modify records in other tables. You can use the LookupRecord, EditRecord, and CreateRecord Data Blocks as required.

However, a data macro cannot run a VBA script. Your actions are limited to those available in the data macro environment itself.

Best Answer

Related Solutions

Ms-access – Access Value between ranges

Ms-access – Access 2010 After Insert data macro to update another table

Related Question