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.