Remove selected numbers from a query

[Anthony G.]

Hello to All...

The source table consists of random numbers: 190, 45, 78 etc...I'd like to filter qite a few of them but I only know how to carry that out for one number - <>78. How would I do that for, let's say, 10 numbers?

Thanks,

Anthony

 

[Norie]

Create a temporary table with the numbers you want to filter on.

Then create a query containing your main table and the new table.

Create a relationship between the numbers in the main table and the new table.

Make it a one-to-many from the new table to the main table.

I.E. set it to show all values from new table and only those that match in main table

 

[Anthony G.]

Very, very cool...

Now, what if I want to prevent those numbers from appearing in the query?

 

[Norie]

You could try going to the SQL and changing the '=' in th JOIN expresion to <>.

Access Query Builde won't like this but it should work.

There are other alternatives involving using subqueries as criteria.

 

[Anthony G.]

That's a little out of my league...anything simpler?

 

[Norie]

When in Query design view go View>SQL View.

The other way also involves SQL.

 

[Anthony G.]

OK...Thank you very much.

Anthony