Thanks, I will try Evi's solution but when I read the blurb in the Access
Help I got the impression that I had to type an expression or value in the
Update To cell and I didn't want to have to do that - I just wanted to
replace the content if it was different. In fact it would not matter if all
matching cells were replaced even if there was no difference.

"John W. Vinson" wrote:

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]