NOT IN?

[Guest]

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

 

[Arvin Meyer [MVP]]

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

 

[Guest]

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.

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

 

[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

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.

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

 

[Guest]

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

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

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.

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