NOT IN?

S

s4

Hi,
I have two tables. I have a query that returns data where the criteria in
field2 is 'IN (
![BARCODE]). This returns matched records.
I need to also list the data in field2 that doesn't match the data in the
other table. I've tried NOT IN, but it returns loads of results that aren't
'not in'.
Thanks, (sorry for the confusing explaination)
Also, does anyone know how to work the Microsoft Toolbar that you add to
forms, or any way to make a toolbar embedded on a form?
Thanks
 
A

Arvin Meyer [MVP]

Not In(array) should work as expected, unless there are other criteria that
also need setting.
 
S

s4

I only have 3 records in the first table at the minute, but when I run the
query it returns 169 records which are repeats of those 3 records. It also
includes records that are found in the other table.

Arvin Meyer said:
Not In(array) should work as expected, unless there are other criteria that
also need setting.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

s4 said:
Hi,
I have two tables. I have a query that returns data where the criteria in
field2 is 'IN (
![BARCODE]). This returns matched records.
I need to also list the data in field2 that doesn't match the data in the
other table. I've tried NOT IN, but it returns loads of results that
aren't
'not in'.
Thanks, (sorry for the confusing explaination)
Also, does anyone know how to work the Microsoft Toolbar that you add to
forms, or any way to make a toolbar embedded on a form?
Thanks
Click to expand...
Click to expand...
 
A

Arvin Meyer [MVP]

That's called a Cartesian Product. It is the result of not having a join
between the 2 tables. You other table has 56 records and there are 168
returned in the query. You need to fix the join.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

s4 said:
I only have 3 records in the first table at the minute, but when I run the
query it returns 169 records which are repeats of those 3 records. It also
includes records that are found in the other table.

Arvin Meyer said:
Not In(array) should work as expected, unless there are other criteria
that
also need setting.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

s4 said:
Hi,
I have two tables. I have a query that returns data where the criteria
in
field2 is 'IN (
![BARCODE]). This returns matched records.
I need to also list the data in field2 that doesn't match the data in
the
other table. I've tried NOT IN, but it returns loads of results that
aren't
'not in'.
Thanks, (sorry for the confusing explaination)
Also, does anyone know how to work the Microsoft Toolbar that you add
to
forms, or any way to make a toolbar embedded on a form?
Thanks
Click to expand...
Click to expand...
Click to expand...
 
S

s4

Turns out it was because one of the fields was Memo format and it works now.
Thanks for the help.

Arvin Meyer said:
That's called a Cartesian Product. It is the result of not having a join
between the 2 tables. You other table has 56 records and there are 168
returned in the query. You need to fix the join.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

s4 said:
I only have 3 records in the first table at the minute, but when I run the
query it returns 169 records which are repeats of those 3 records. It also
includes records that are found in the other table.

Arvin Meyer said:
Not In(array) should work as expected, unless there are other criteria
that
also need setting.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Hi,
I have two tables. I have a query that returns data where the criteria
in
field2 is 'IN (
![BARCODE]). This returns matched records.
I need to also list the data in field2 that doesn't match the data in
the
other table. I've tried NOT IN, but it returns loads of results that
aren't
'not in'.
Thanks, (sorry for the confusing explaination)
Also, does anyone know how to work the Microsoft Toolbar that you add
to
forms, or any way to make a toolbar embedded on a form?
Thanks
Click to expand...
Click to expand...
Click to expand...
 
Top