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.