Can I say use NOT IN operator on a query?

I have one query that does some logic to get a result that has a list of registrations numbers

in another query, i want to do some logic and part of that is.

and RegNo NOT IN (firstQry.RegNo)

Is this possible?  when I try to setup up the queries in Access, it asks me to enter the value for firstQry.RegNo, so I'm either doing something wrong or it is not possible to do this way.
LVL 5
jjacksnAsked:
Who is Participating?
 
peter57rCommented:
Hi jjacksn,
 and RegNo NOT IN (Select Regno from firstqry)


Pete
0
 
wesbirdCommented:
after the IN it needs to be a complete select query

e.g.
NOT IN (SELECT RegNo FROM .... WHERE .... )
0
 
jjacksnAuthor Commented:
ah, thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.