searching unmatching records


J

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
 
Ad

Advertisements

J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top