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.
 
Back
Top