not in query for composite key

[inungh]

I would like to have a not in sub query in my query and just realized
that the table is composite which has 2 fields for primary key.

Does Access support that composite key not in queries?
If yes, any examples?
If not, any workaround?

Your information is great appreciated,

 

[Marshall Barton]

I would like to have a not in sub query in my query and just realized
that the table is composite which has 2 fields for primary key.

Does Access support that composite key not in queries?
If yes, any examples?

Try using an unmatched query instead of Not In. There's a
query wizard that should get you started.

If that does not do what you need, post back with details of
what your tables look like and what you want the query to
do.

 

[inungh]

Try using an unmatched query instead of Not In.  There's a
query wizard that should get you started.

If that does not do what you need, post back with details of
what your tables look like and what you want the query to
do.

Thanks for the message and helping,
It works fine,
Thanks millions,