Notes In a Report

[sturner333]

I have a report that looks like the following:

Market
Project#1
Note
Project#2
Note
Project#3
Note
Market2
Project#1
Note
Project#2
Note
Project#3
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

 

[KARL DEWEY]

Open report in design view, click on the text box displaying project#, click
on menu VIEW - Properties, set Hide Duplicate to Yes.

 

[RBear3]

When you pull your data, you need to pull the data you want and then build
your grouping and sorting options to group and sort by "Market" and include
a group header. in the header, you would include the "market" field. Then
your next level in grouping and sorting would be by "Project#". Again,
you'd include a group header and in this header you'd put your "Project#"
field. Then, in the body of your report you'd put the "notes".