Comparing Two Databases

jaiD

Board Regular
Joined
Jun 13, 2004
Messages
92
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
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,839
Office Version
  1. 365
Platform
  1. Windows
Try using the "Find Unmatched Query Wizard" in Access.
The wizard should walk you through all the steps.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,811
Messages
5,544,437
Members
410,610
Latest member
renatha prado
Top