New to this so i will explain as best i can.
I am using office 2000 access.
I have master table and table 1. both with mail addresses.
I have linked the two tables and when i use query the results table has the two lists of matching data side by side.
How do i remove these items from table 1. thus leaving table i with the fresh data.
Hope this makes sense.
Thanks

If you want to update the addresses in the master table with the addresses from tbl1, you need to use an update query. Change the query type to Update. Remove all the selected columns from tbl1. In the Update To field place the name of the field in tbl1 that you want to update from. Make sure the reference is in the format tbl1.[fieldname].

Of course before running any type of update query, the most prudent course of action is to back up the data.

Once you are satisfied that the update was properly completed, you can delete tbl1.