Filtering specific data

[LEXCERM]

Hi there,

I've been trying to work this out for ages, but can't get my head around it.

Example data:
A = 1
A = 2
B = 1
C = 1
C = 2
C = 3
D = 2
E = 1
E = 3

I want a query to filter-out any letters that have a value of 1 or 2, but not 3.

Therefore, the result for the above data would be: A, B, D.

Thanks in advance.

 

[John Big Booty]

You will need to do this in two steps first create a query that selects all the records that have a value equal to 3. No using the New button at the top of the Query window use the Find Unmatched Query Wizard, to create the query that will return the results you are after.

The first step will be to select the table that contains all your records, next select the query that you have just created. The link will be the field that contains the letters, and from there simply follow the bouncing ball.