create report to cut-n-paste into word table

[mdnuts]

I have a report that groups by a project name and then a repeating field to list all associated detail having to do with the project. Then the projects loop to the next.

(sorry for the periods in place of spaces - I couldn't see how to line up correctly otherwise.)

This is what I'm shooting for. Each project row is the same height as the combined detail rows. And to be able to print guidelines just as you would with a word table.

+-------+-----------------+---------+
| Project |.-detail row 1......| Open.....|
|...........|.-detail row 2......|.............|
|...........|.-detail row 3......|.............|
+-------+-----------------+---------+

This is what currently happens.
+-------+-----------------+---------+
| Project.|.-detail row 1......| Open.....|
+-------+-----------------+---------+
............|.-detail row 2......|
............+-----------------+
............|.- detail row 3......|
............+-----------------+

What do I need to do? In my mind I'm thinking I need to do it with vba putting each into a variable then set the field to be the value of the variable. but i'm also not sure how to do that as it repeats like that.

 

[BlueIshDan]

send a screen shot of it in design view. Seems to be that you just have some extrea space in your detail design area.

 

[BlueIshDan]

You can also redesign to use a group header.

 

[mdnuts]

Thank you for the reply.

Attached the image that I hope clarifies it. The bullet point isn't a necessary thing I just have it in there for now.

 

[BlueIshDan]

Ok so like I said, we're going to have to either have a sub query that joins your 3 distinct status/issues into a single field in the return collection or redesign your report.

You have to think about your set of data that is being returned. and how it is displayed.

 

[mdnuts]

I'm assuming trying to populate it with VBA is a futile effort?

 

[JHB]

Why are you not satisfied with the report you get?
What if you remove the border around the controls and drawn a line in the Project group footer?

 

[BlueIshDan]

remove extra space in the details portion of your design view.. above and/or below your text boxes. Might do the trick.

 

[mdnuts]

Seems to keep producing the extra rows for each record in the repeating field.

I may have figured a way to get it to work - taking the results, combining the repeating row into one cell then save it to a table and pull the report off that table.

Working through quirks for now.