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".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

One Result from multiple memo fields 10
One result from multiple memo fields 1
Report alignment problem 6
Line-by-line formatting in Excel 2007 Textbox 3
Excel VBA - counting cells by colors and names to it in two different rows. 0
Difficult Report 2
Need help inserting comment box into Access invoice report 1
showing last memo entry in report 3

Back
Top