Group Records by Key 1

[mkallover]

I'm drawing a total blank on how to do this for some reason. I've created a basic project management database that stores information for projects in a table and has another table to track any "issues" that come up for each project. The two are linked by a field call CPOProjectNum that is a unique identifier.

I created a query that displays any project with issues that have a status of "Open" and now I want to create a report based on that. What I would like the report to do is to have a header for each project and then list any open issues underneath it. I was trying to use the Group/Sort options of the report editor but this is giving me a section for each record in the query instead of a section for each unique project number.

Would I have to use a subreport to accomplish this or is there some other option that I'm not considering?

 

[MajP]

It should work as you described. You should group on "CPOProjectNum" and make a header for that section. In the header put the information unique to a Project. In the details section have issue information.

Can you describe what you grouped on and all of the sections?

 

[mkallover]

Hmmm, strange. I tried using ProjectName as the group header and now it is working.

I must have done something wrong the first time. Thanks.

 

[MajP]

ProjectName works too. Any field unique to a project would work.