distinct rows

[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"));

 

[Duane Hookom]

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

 

[Guest]

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

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
--

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"));