Hello, I need some help with First Criteria statement or DISTINCT. I
would like the Par # column to have all distinct or just the first
value it encounters. I tried to add the criteria in access, but it
still outputs the same data as before. I already have two first
criterias in the query , I am not sure if that is causing the problem.
If someone could help me make the Par # column distinct also or using
the first criteria, that would be great. Thanks in adv
SELECT newPARdata.[PAR #], newPARdata.[EPAR?] AS Expr1,
newPARdata.[PAR Type], First(NZ(CNames.[CompD],"OTHER")) AS Expr2,
First(NZ(CNames.COMPID,"OTHER")) AS Expr3, newPARdata.[Opened Date],
newAPARdata.[Closure Date], newPARdata.[Sev], newPARdata.PE,
newPARdata.Hip, newPARdata.Out, newPARdata.[PGT #],
newAPARdata.[FLevel], newPARdata.[PGT Target], NZ([PGT Closed
Date],"Empty") AS [PTF Closed]
FROM newPARdata LEFT JOIN CNames ON newPARdata.[CompoID]=Names.COMPID
GROUP BY newPARdata.[PAR #], newPARdata.[EPAR?], newPARdata.[PAR
Type], newPARdata.[Opened Date], newPARdata.[Closure Date],
newAPARdata.[PAR Sev], newPARdata.PE, newPARdata.Hip,
newPARdata.Outage, newAPARdata.[PTF #], newPARdata.[FLevel],
newPARdata.[PGT Target], NZ([PGT Closed Date],"Empty")
ORDER BY newPARdata.[PAR #];