Filter a report so it doesn't display certain records

[crisenr]

hey everyone . .

i've got a report which pulls its data from a query. it pulls these fields:TestCode...Price...HID...Month...etc . . .

There are names of "TestCode" that we don't want to display, is there a way to filter certain "TestCodes" out? if so, how?

Here's my current SQL Code:
I have a query which pulls certain records from a table, here is my SQL statement:
SELECT [qryGroupByAMCount].[TestCode], [qryGroupByAMCount].[Price], [qryGroupByAMCount].[HID], [qryGroupByAMCount].[Month], [qryGroupByAMCount].[CountOfAutoNumber], IIf([TESTCODE]="PTCGCD",[CountOfAutonumber]*2,IIf([TESTCODE]="LSHABC",[CountofAutonumber]*4,IIf([TESTCODE]="HPVPNL",[CountOfAutonumber]*2,IIf([TESTCODE]="TOXOAB",[CountofAutonumber]*2,[CountofAutonumber])))) AS Extended
FROM qryGroupByAMCount

 

[GumbyD]

In the design view of the query in the grid section (bottom half) under the "Test Code" field in the "Criteria" row type in the following

Not "TestCodeValue1" and Not "TestCodeValue2" and Not ...

Of course you will have to put in real data values instead of "TestCodeValue1" and so on.