I have now run Append and Update queries on a copy of the database and I am
now in the process of appending records for updates.

I only get a copy of the database filtered for my branch. I think I said
previously that in the lists HQ send me, they don't include those who have
left. I am trying to get them to denote deaths, resignations and suspensions
as I don't want to send emails to dead people pursuading them to rejoin. So I
need to compare current and updated lists to identify the leavers.

Thanks for your help. I'll be back when I have suceeded or failed.

"Fred" wrote:

Couple of notes from the sidelines:

- Another way to get it is via the "query" dropdown menu when in design mode
in a query


- Sounds to me like your HQ is actually maintaining the membership database.
You are receiving and using copies of it. Can you just import and directly
use the whole thing that they send you each time?