[AccessD] comparing tables

Gustav Brock gustav at cactus.dk
Tue Oct 19 04:10:53 CDT 2004


Nice catch Arthur!

/gustav


> 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