If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Trying to find values that are not equal
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! |
Thread Tools | |
Display Modes | |
|
|