duplicates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am running the query below. There is dupes on the group and subgroup that
I want to eliminate. where does the distinct clause go? thanks

SELECT [LRSP FINAL].[HP SERVICE LEVEL], [LRSP FINAL].[HP DESCRIPTION], [LRSP
FINAL].[HP CARVE OUT], [LRSP FINAL].[GROUP APPLICATION CODE], [LRSP
FINAL].[GROUP PROGRAM FROM DATE], [LRSP FINAL].[GROUP PROGRAM THRU DATE],
[LRSP FINAL].GROUP, [LRSP FINAL].SUBGROUP
FROM [LRSP FINAL]
WHERE ((([LRSP FINAL].[HP SERVICE LEVEL])="00010"));
 
You would normally make the query a "totals" query that groups by specific
fields and performs aggregates on others.
 
Back
Top