On Fri, 21 Mar 2008 12:21:01 -0700, Pennington
wrote:

I have encountered a problem.
When I run the Append Query it adds new members to the Members Table and
does not add duplicates which is fine but I want to also update the Members
Table where the data in a field is different (The Primary Key will not change
but titles, addresses and e-mails may change). I have looked at an Update
Query but this is not appropriate. What other type of query can I use for
this?

In what way is an update query inappropriate? If you want to update existing
records from a second table matching by primary key, an Update Query is
exactly what you would use!

--

John W. Vinson [MVP]