• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 346
  • Last Modified:

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.
0
jjacksn
Asked:
jjacksn
2 Solutions
 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now