Proper way to bundle

[goslincm]

I have the following query that I am running, but what I want to do is only display the [UNIT NAME] field once, but list each of the replies in the [QUESTIONS_MAILOUT] field.

Can this easily be done or done with the start I have?

SELECT [AUDIT REVIEWS].[UNIT NAME], AUDITRPT_QUESTION.QUESTION_MAILOUT, AUDITRPT_RESPONSE.QUESTION_YN, [AUDIT REVIEWS].[FYE 2000]

FROM (AUDITRPT_QUESTION INNER JOIN AUDITRPT_RESPONSE ON AUDITRPT_QUESTION.QUESTION_CODE = AUDITRPT_RESPONSE.QUESTION_CODE) INNER JOIN [AUDIT REVIEWS] ON AUDITRPT_RESPONSE.AUTONO = [AUDIT REVIEWS].AUTONO

WHERE ((([AUDIT REVIEWS].[FYE 2000]) Between #1/1/2007# And #8/31/2007#))

GROUP BY [AUDIT REVIEWS].[UNIT NAME], AUDITRPT_QUESTION.QUESTION_MAILOUT, AUDITRPT_RESPONSE.QUESTION_YN, [AUDIT REVIEWS].[FYE 2000]

HAVING (((AUDITRPT_RESPONSE.QUESTION_YN)="n"));

 

[jrbarnett]

Create a report based on this query.

Set up a group header based on the unit name. Put the Unit name in the header, and all other fields in the detail band.

John

 

[goslincm]

Thanks John