Filter a report so it doesn't display certain records

crisenr

New member
Local time
Yesterday, 23:28
Joined
Oct 6, 2005
Messages
8
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
 

Users who are viewing this thread

Back
Top Bottom