Display one records with multiple Notes

[soontobefour]

I have a report that has reports: incident, status, severity, description, and notes. The Notes reside in a seperate table and each incident can have multiple notes. I only want the Incident information to appear once, but have the additional notes listed below it.
Right now I have a query that pulls the notes in and I also have a counter to count how many times the incident number is listed, but i don't know how to not display the incident details and display the notes.

I want it to look like this:

IncidentID Status Severity Description Notes 101 New High incorrect data added data
format data
105 test Med wrong flow change picture
insert field


Thank you

 

[dhookom]

Try:
1) hide duplicates
2) remove the notes from the main report and place them in a subreport


Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[soontobefour]

dhookom,

I tried hiding, but since some of the data would be duplicates such as: status and date, I was missing data. So, I have used the subreport method.

Thanks.