Writing query to exclude information

[minnie]

I have run a query with certain criteria in it, but I need to exclude 5 or 6 of the records that it bought up. There is no one determining factor for these particular records that I find. I can't delete them because I don't want to delete them from my main table. What I would normally do is write a query using the ID # that we attach to each record and just not include the 5 or 6 ID #'s that I don't need. Is there an easier way to do this? Now I have returned about 50 records and I don't want to have to plug in each ID #. Is there a way that I can say "exclude ID#__, __ and ___?

Any assistance would be greatly appreciated!!

 

[mitchem1]

You might be able to add a Yes/No type column to your table and assign the records you don't want to include = No. Then query on records = Yes.