[AccessD] comparing tables

Arthur Fuller artful at rogers.com
Mon Oct 18 14:21:34 CDT 2004


Susan Harkins wrote:

>I've got some SQL code that compares two tables and reports on records that
>aren't in both tables. I did a bit of checking to be sure, but I can't find
>any built-in Access feature that does this -- anyone know of a wizard or
>something that I might have missed? I'd hate to recommend something that's
>not necessary. 
> 
>Susan H. 
>  
>
That must be some bitchin' code, rather like the SQL underlying such 
statements from "Star Trek" as, "Scan the federation databases for 
anomalies."

I would suggest that the set of records not found in both tables is 
infinite, to say the least. :)

A.



More information about the AccessD mailing list