Comparing Two Databases

[jaiD]

Hi,

I have two databases, both run at different times of the year ie six months apart. I now need to run these databases against each other to see which members have left.

Data looks as follows:
(old data)
Membership No Name Age Paid Date
128 Jo 32 2 12/06/2006
290 Rob 22 1 15/06/2006
360 Chris 20 4 11/06/2006
(new data)
Membership No Name Age Paid Date
128 Jo 32 2 12/06/2006
360 Chris 20 4 11/06/2006

So database just needs to check by membership no to see if membership is no longer active, I want it to be displayed as members that have left so it would show as follows:

Membership No Name Age Paid Date
290 Rob 22 1 15/06/2006

 

[Joe4]

Try using the "Find Unmatched Query Wizard" in Access.
The wizard should walk you through all the steps.