Trying to find values that are not equal

Hi;
I am a new user... I have the same field in two different tables. I tried a
query to find the records where the values are not equal. I used the
expression builder but got zero records which I know is not correct. I tried
expression builder using the following:
Table_A, Field = RSL_1
Table_B, Field = RSL_1 =There is a right join only from table A to B (I
only want to see the unequal values in Table A)

I entered the following select query criteria under RSL_1, Table_A
[Table_B]![RSL_1]. I also tried 'Not Like' instead of and got no
records for either. Does anyone know what I'm doing wrong?
Thanks!

Select *
From Table_A
Where RSL_1 Not In (Select RSL_1
From Table_B) ;

Or in query design view put the following in the criteria of the RSL_1 field:

Not In (Select RSL_1 From Table_B)

If you want to see the opposite results, switch the table names.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Cindy" wrote:

Hi;
I am a new user... I have the same field in two different tables. I tried a
query to find the records where the values are not equal. I used the
expression builder but got zero records which I know is not correct. I tried
expression builder using the following:
Table_A, Field = RSL_1
Table_B, Field = RSL_1 =There is a right join only from table A to B (I
only want to see the unequal values in Table A)

I entered the following select query criteria under RSL_1, Table_A
[Table_B]![RSL_1]. I also tried 'Not Like' instead of and got no
records for either. Does anyone know what I'm doing wrong?
Thanks!