In Access you just use a SQL query. This will give you all the Club A
members who are not members of Club B

SELECT a.IC FROM ClubA a
LEFT OUTER JOIN ClubB b
ON a.IC = b.IC
WHERE b.IC IS NULL


"Doeu" wrote:

Urgent work! I have two excel membership database, Club A & Club B.

I need to find out all the members who join Club A & B, and Club A members
who haven't join Club B. I will need to check it by tracing the IC(unique:
combine characters & numbers)

Anyone can advise on this? As for as I know, SQL able to solve this. Is it
possible to solve it in Excel and Access?

Thanks!