Reports to look the same

[GACat]

I am creating a report that shows members of a team - al completed in the details sections of the report

I would like for each page of the report to look the same - ie same number of boxes, lines, etc.

My issue is that most teams will have 7 members while some will have less.Is there any way to create a report that will always show 7 lines?

Would it be better to do this in Access or just create a mailmerge in Word?

Thanks for you assistance in insight.

 

[vbaInet]

I imagine it can be done, but not with ease. It's a slightly complicated issue in Access so you may want to resort to merging to Word. If you don't have experience coding then you won't be able to do it, but here's the idea:

1. Create a table that will have the TeamID field plus the exact number of fields there are in the Members table
2. Using a recordset count how many members there are in each team.
3. For each team less than 7 run an INSERT query to INSERT into the table you created in 1, the TeamID and MemberID for as many times as needed to make it 7.
4. Use a UNION ALL query to combine your Members table with the query you created in 3.
5. Now use this query in your reports.

This whole operation would need to be performed in code before the report is opened.

Here's a link on the UNION query and why you should use UNION all:

http://www.techonthenet.com/sql/union.php