Excluding records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear all,

I have a big data base and I want to run a query that will exclude from this
data base individuals that are listed in a seperate file, how can I do that?
When I want to do a query, the only option is join when field are equal, is
there a way of specifying NOT equal somewhere?

Thanks a lot!
 
Use the wizard to create an UNMATCHED query. It will do what you are trying
to do here.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exclude most recent month 3
Parameter Value error in a Subform 0
Access Remove rows based on multiple fields 2
how can I exclude records if they equal? 4
excluding 12:00:00 AM from query results 4
Run a Query that Excludes Values in A Table 4
Exclude additional duplicate account numbers 2
Create a query when table has a look up in it 3

Back
Top