View Full Version : Writing query to exclude information


minnie
03-01-2002, 06:19 AM
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
03-01-2002, 07:10 AM
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.