distinct rows

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

Guest

Is there a way you can edit the below so I have distinct rows? I may have
the same group number on several rows, but the subgroup may vary. I don't
want any duplicate rows? 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"));
 
Is this the same question you posted earlier? If so, please keep to the one
thread where there is at least one reply.
 
thanks. my esperience is that I do not get followup replies. The initial
response was to broad...I did not know what to do. thanks

Duane Hookom said:
Is this the same question you posted earlier? If so, please keep to the one
thread where there is at least one reply.

--
Duane Hookom
MS Access MVP
--

JRS said:
Is there a way you can edit the below so I have distinct rows? I may have
the same group number on several rows, but the subgroup may vary. I don't
want any duplicate rows? 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"));
Click to expand...
Click to expand...
 
Back
Top