hi, i need to compare two tables in ACCESS 2003.
There is a master memebership table1 that i need to compare with membership table2. I need to find the missing members in table2 that are active in table1.
In other words i need to compare active memebers in table 1 to active memebers in table 2 and run a reports of all the memebers missing in table 2.
I will need to run this report based on the ID# in table1 that is not termed and is not listed in table2.
Can someone please help me?
Start Free Trial