Prev: Update Query to a SharePoint List
Next: Case or IIF?
From: Cindy on 1 Jul 2008 15:05
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!

From: Jerry Whittle on 1 Jul 2008 15:34
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!
>
 | 
Pages: 1
Prev: Update Query to a SharePoint List
Next: Case or IIF?