Append and delete

  • Thread starter Thread starter Ohio5
  • Start date Start date
O

Ohio5

I have two tables, I want to append data from Table1 that
does not exist in Table2 and then delete from Table1 that
data that was appended. How do I do that?
 
Add the two tables to a query, then you have to create a
relantionship between the two. By either the custname &
zip or something that is unique to the two tables. Then
on that line going between the two tables you can edit the
type of query you want. You ask for all of the data that
is in table1 but not in table2. To open this window
double click on the relantionship line going between the
two tables.
 

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

Update or Append Query in Access 2003 2
append query 1
Help with append query 4
join keeps cascading 2
Updating one table from another table 4
SQL Statement Insert Into 5
append query 7
delete records and modufy records 2

Back
Top