Grouping in a table

[Guest]

I currently have a query that gives me Project Numbers and certain
information associated with those projects. In a one-to-many relationship,
the query includes several companies that received information on each
project.

From it I will generate a report that shows each project by number and the
companies that were issued the information. How do I create a report that
prints the project number only once but gives me the detail of all the
companies associated with it?

 

[Douglas J. Steele]

With the report open in design mode, take a look at the Sorting and Grouping
dialog (if you can't figure out which button that is, look under the View
menu). Ensure that the project number is chosen, and then say you want a
Group Header. Add the project number field to the header, not the detail.

 

[Guest]

Karen,

If you want a simple list, simply set the HideDuplicates property of the
report control bound to the Project Number to Yes. The project number will
print once and be blank for all subsequent records.

Alternatively, you could create a Grouping (View, Sorting and Grouping) on
Project Number, create a heading, and place the project number in the
heading. This would allow you to scoot the company fields further to the
left, giving you more room on the page.

Hope that helps.
Sprinks