Adding Criteria to existing SQL 1

[netrusher]

How can I add criteria to the SQL Code below that will Query when WorkUnitsFaultsMainTBL.BuildID = F187 or A910? I want the results of my query to look as they do now.

SystemGroup Mechanical Totals
Cowl-------------------------5
OHG-------------------------3
Brake-----------------------10 etc. etc.

Select SystemGroup, Count(*) As [Mechanical Totals]
From WorkUnitsFaultsMainTBL
WHERE (((WorkUnitsFaultsMainTBL.FaultCategory)<>"No Faults") AND (WorkUnitsFaultsMainTBL.FaultCategory)<>"Cosmetic") And  ([TodaysDate] Between [Forms]![WorkUnitsFaultsMainFRM]![StartDateTxt] And [Forms]![WorkUnitsFaultsMainFRM]![EndDateTxt])
Group By SystemGroup

UNION ALL Select 'Total Work Units', count([WorkUnit]) from (select distinct [WorkUnit]
From WorkUnitsFaultsMainTBL
WHERE (((WorkUnitsFaultsMainTBL.FaultCategory)<>"No Faults") AND (WorkUnitsFaultsMainTBL.FaultCategory)<>"Cosmetic") And  ([TodaysDate] Between [Forms]![WorkUnitsFaultsMainFRM]![StartDateTxt] And [Forms]![WorkUnitsFaultsMainFRM]![EndDateTxt]));

 

[AlexCuse]

Add something like this to your where clause?

AND WorkUnitsFaultsMainTBL.BuildID in ("F187", "A910")

Hope this helps,

ALex

Ignorance of certain subjects is a great part of wisdom

 

[netrusher]

Thanks Alex,

Works Perfect!!