Notes In a Report

  • Thread starter Thread starter sturner333
  • Start date Start date
S

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
 
Open report in design view, click on the text box displaying project#, click
on menu VIEW - Properties, set Hide Duplicate to Yes.
 
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".
 
Back
Top