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]

Post by 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

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

Post by jean
[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.