Append tables

  • Thread starter Thread starter indigo993
  • Start date Start date
I

indigo993

How do I append a table so that Table 1 gets updated with dates from Table 2?
Currently there is a empty column for dates in Table1.
 
Sounds like you want to UPDATE and not APPEND. Append adds records while
update changes values in a field.

BACKUP the database. BACKUP the database.

Create an unmatched query using a common field like SomethingID. Open the
query in design view, click on the line connecting the tables, then double
click on the line. Select the top option - where fields are equal. Remove
the 'Is Null' from the Criteria row.
Add the field to be updated and to be used to perform the updating.
Add criteria. Run query and review data.
Copy the field to be used to perform the updating and paste inside of
brackets in the Update To row under the field to be updated. If the field
names are the same then include the table name also like this --
[TableName].[FieldName]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Values Of External Table Into Current Data Table 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How to export table from outlook into ms access table? 0
Append Query Issue 0
Access Access 2010 import/append data into table w/o overwriting existing records 0
Relationships in querries 1
Access Macro Repeat Expression using value of a field in table 0
Automate Append Query to Run Whenever New Records Post 3

Back
Top