look at the join clause.. its going to be something like...
select A.column1, A.column2....., B.column1.... from mytablea as A join mytablex as B on B.columnname=A.columnname
tweaking the join will show records wich have the same userid
show all the records in table one which aren't in tablex and vice versa
have a look at the query qizard.. it has options that will write that query for you
if you need to match all columns to find if they are identical then you could do that in a query or in vba. write a query which extracts all records from both tables
iterate through that query
then do a comparison in vba to see appropriate columns match
I am really looking compare each field in the records of both Tables where those records have matching ID field values, plus identify which records have no match in the unique ID. Looks like SQL is the way to go, as per healdem. Going to be tedious, wth each record having 80 fields.