not in query for composite key

I

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,
 
M

Marshall Barton

inungh said:
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?
Click to expand...


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.
 
I

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.
Click to expand...

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