Notes In A Report

[sturner333]

I have a report that looks like the following:

Market
Project#
Note
Project#
Note
Project#
Note
Market2
Project#
Note
Project#
Note
Project#
Note
Sometimes a given Project# has multiple notes entered. Right now my report will handle the multiple notes by rewriting the Project# each time. I would like to list all the notes for a given Project# under that Project#:

Market
Project#1
Note1
Note2
Project#2
Note1
Project#3
Note1
Note2
Any ideas?
Thanks

 

[ck1999]

Did you try group by project?

ck1999

 

[sturner333]

This would be in the sorting and grouping section. What would I enter for this. I can give you more info if you need it.
Thanks

 

[ck1999]

Whatever if your field name for project#1, project#2, project#3,etc.)

Select grouping and add this field, choose ascending.

Then I beleive under view or edit choose group header.
In the group header place the field [projectfield] (or whatever you call it) then in the detail section place the field for notes.

ck1999