By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,527 Members | 1,184 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,527 IT Pros & Developers. It's quick & easy.

Access Query help!!

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

Nov 13 '05 #2

P: n/a
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;
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.