Susan Harkins
ssharkins at bellsouth.net
Wed Oct 27 08:41:33 CDT 2004
There's a wizard for that. Try the Duplicates wizard. Susan H. Hello Group, i have a table in which i would compare two fields in one record with each other. The result must be the record where one of the values don't match with one another. fieldA fieldB and several other fields 00123 00123 02345 02345 06789 06689 result fieldA fieldB and several other fields 06789 06689 Is this possible. Thanks Pedro Janssen -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com