SELECT "Order Type Group Reactive" AS OrderTypeGroup,tblKOB1.[Cost element name],
SUM([Valin repcur]) AS TotalAmount
FROM qryIW37N_WOGrp INNER JOIN tblKOB1
ON qryIW37N_WOGrp.Order = tblKOB1.Order
WHERE ((qryIW37N_WOGrp.[Location] = [Enter Location])) AND ((tblKOB1.[Fiscal Year] = [Enter FY])) AND (((tblKOB1.[Cost Element]) Not In ("522005","522180","522195","522200","522205","523105","523010","523900","524025","526050","528020","528040","529005","530090","534040","534900","536010","536015","536020","536030","536105","536900","539005","546460","800117","800119","800120","800121","800127","800129","800130","800141","800144","800152","800154","800171","800198","800199","800221","800256","800258","800230","800263","800298","800299","800419","890001","890006"))) AND ((qryIW37N_WOGrp.[Order Type] IN ("18","18RL","AFF","OM05","RFS")))
GROUP BY tblKOB1.[Cost element name]
UNION ALL SELECT "Order Type Group PRV",tblKOB1.[Cost element name],
SUM([Valin repcur])
FROM qryIW37N_WOGrp INNER JOIN tblKOB1
ON qryIW37N_WOGrp.[Order] = tblKOB1.[Order]
WHERE ((qryIW37N_WOGrp.[Location] = [Enter Location])) AND ((tblKOB1.[Fiscal Year] = [Enter FY])) AND (((tblKOB1.[Cost Element]) Not In ("522005","522180","522195","522200","522205","523105","523010","523900","524025","526050","528020","528040","529005","530090","534040","534900","536010","536015","536020","536030","536105","536900","539005","546460","800117","800119","800120","800121","800127","800129","800130","800141","800144","800152","800154","800171","800198","800199","800221","800256","800258","800230","800263","800298","800299","800419","890001","890006"))) AND ((qryIW37N_WOGrp.[Order Type] IN ("OM02","UM01","UM02")))
GROUP BY tblKOB1.[Cost element name];