compare

[rob p]

I have two data bases. One from 2003 and one from 2004. All have 4 position
alpha-numeric ID. Is there a quick way to compare both lists, for matches,
for omissions, for entrys in only one or the other. This without manually
matching one to one. (there are thousands).
thanks.
rob

 

[Steve Schapel]

Rob,

Import the relevant tables from one database into the other. In the
Database Window, select Queries tab, then click New, and you will see an
'Find Unmatched Query Wizard' on the list in the popup window. I think
this will probably serve your purposes.

It may be worth considering normalising this data, by combining the
data, and adding an extra field to indicate the applicable years.