searching unmatching records

[jean]

Hi

I have a database containing 2 fields and 5,00 records

First field "CodeItem" (duplicate allowed) and second field
"Description" table is "TblItems"

I want to find all records that have the same CodeItem but a different
Description (track errors)

How can I do that easily

Thanks

 

[John W. Vinson]

Hi

I have a database containing 2 fields and 5,00 records

First field "CodeItem" (duplicate allowed) and second field
"Description" table is "TblItems"

I want to find all records that have the same CodeItem but a different
Description (track errors)

How can I do that easily

Thanks

Well... to use Access terminology, you have a Table. A Database is the
container (the .mdb or .accdb file) for multiple tables, forms and other
objects.

Create a "Self Join" query by adding your table to the query design grid
twice. Access will append a _1 to the name of the table for the second
instance. Join the two tables by CodeItem; select one of the CodeItem fields
(doesn't matter which, they're the same value) and both Description fields. On
the second Description field put a criterion

[TblItems].[Description]

This query will show all records with matching CodeItem but different
Descriptions.

Note I said > - "greater than" - not <> - "Not equal"; you can use <> but then
you'll see each mismatch twice, with both orders for the descriptions.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com