[AccessD] comparing tables

Stephen Bond stephen at bondsoftware.co.nz
Sat Oct 16 22:06:25 CDT 2004


The restriction on this wizard is that it allows only one left join at the wizard stage.  If there are a number of fields I want to compare in 2 tables, I manually insert/delete left joins in the Design View after the wiz has done its stuff..

Stephen Bond

> -----Original Message-----
> From: Susan Harkins [mailto:ssharkins at bellsouth.net]
> Sent: Sunday, 17 October 2004 2:59 p.m.
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] comparing tables
> 
> 
> Hmmmmmm... I thought about that one, but haven't gotten the 
> exact results I
> was after -- will look at it again. 
> 
> Susan H. 
> 
> Can't the 'Find Unmatched Query Wizard' do that?
> 
> 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 



More information about the AccessD mailing list