Detail Section

[NUWildcat]

I have a report which produces a list of names from a query. The query is based on projects that the people have worked on and so I am searching the table with the query and filtering by the type of project specified. When the report comes up though in the detail section it shows a persons name multiple times because there is more than one project they have worked on. I have used the hide duplicates command and while that makes the name dissapear, there is still a blank space where the name would be. Is there any way to make the space dissapear too or make the name only show up once? It would make the report easier to read and more professional. Thanks in advance.

 

[RichB]

In your report, design format, click the sorting and grouping icon. Select the name and your report will list the name only once and every record with that name will appear. This will list down through all names in the table.

Rich

 

[NUWildcat]

For some reason that didnt work out. This report is only the one field, and so it only lists names of people whose projects fit that type. So there are no other related fields that it needs to group by. I just dont want there to be blank spaces between the names, because when I get a lot more data in my database, there will just be large gaps between each name since they will have so many projects associated with them and it will spill on to other pages, and not be very neat. Thanks for the help, and any other ideas would be appreciated.

 

[Tracy]

Do as RichB says, but before shutting down the Grouping and Sorting Box, set the field 'include group header' to 'yes'. Then put the name field in the group header section which now appears on the report, leaving the details for each name in the detail section.