Access Query help!!

[jwmckin]

I have 2 fields in 2 seperate tables with text strings as the data.
The two fields do not have the same number of entries. I need to
compare the larger of the 2 fields to the smaller field and look for
entries that are not equal. The larger field has duplicate entries. I
have tried a StrCompare query and I get results but its based on
comparisons of the smaller field. I know this is a little confusing if
you are just reading it but any help would be appreciated. Thanks in
advance.

[Larry Linson]

It would be less confusing if you included the SQL that is failing you, and
the actual names of the tables and fields involved. With only a "high level
description" of the problem, it seems unlikely that anyone will be able to
offer useful suggestions.

Larry Linson
Microsoft Access MVP

"jwmckin" <jw*****@yahoo.com> wrote in message
news:73**************************@posting.google.c om...

I have 2 fields in 2 seperate tables with text strings as the data.
The two fields do not have the same number of entries. I need to
compare the larger of the 2 fields to the smaller field and look for
entries that are not equal. The larger field has duplicate entries. I
have tried a StrCompare query and I get results but its based on
comparisons of the smaller field. I know this is a little confusing if
you are just reading it but any help would be appreciated. Thanks in
advance.

[Pieter Linden]

jw*****@yahoo.com (jwmckin) wrote in message news:<73**************************@posting.google. com>...

I have 2 fields in 2 seperate tables with text strings as the data.
The two fields do not have the same number of entries. I need to
compare the larger of the 2 fields to the smaller field and look for
entries that are not equal. The larger field has duplicate entries. I
have tried a StrCompare query and I get results but its based on
comparisons of the smaller field. I know this is a little confusing if
you are just reading it but any help would be appreciated. Thanks in
advance.

How about some sample/example data for clarification?

Sounds like you want an outer join...

SELECT table1.field1
FROM table1 LEFT JOIN table2 ON table1.field1=table2.field1
WHERE table2.field1 IS NULL;