Compare 2 access tables

Topic

New Reply

Is there a way In access 2003 to do this-see Excel attachment

I get a list of Expires from the main office once a week—she always sorts the list by the patient name before she emails it out. I use this formula in excel –which compares the old list and the new list of names– and tells me if any new name was added to the list.

=IF(ISNA(MATCH(A2,names,FALSE)),”Add to Expired”,”allready on list”)

I have over 381,275 list of patient names in a Access table –(Active Patients) that I need to compare to the Expired Access Table which is 70,000 names long.

Can this be done?

Reply | Quote

Replies

Actually Access is quite good at doing that sort of thing – as long as you have unique identifiers. The Query Wizard can create Unmatched results between two tables and does it using what is called an Outer Join. But if your table structure is similiar to the Excel workbook you attached, it appears that there is a high probability of duplicates based just on the name. Does the main office send the 70,000 list of expired patients every week?

Reply | Quote

Does the main office send the 70,000 list of expired patients every week?

Yes the main office sends the expired patient list every week

Reply | Quote

Here is what your query would look like – using the tables you supplied.

Reply | Quote