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
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