Selecting one item at a time from table column to display on report.

[BatmanMR287]

I have a table that has groups of 8 people in one column. I need to pull each one (from one group) at a time to print their name on report. Each group has a unique number and each of the 8 people have a unique number as well. The unique number for each of the 8 people is an auto number and are always sequential.
How do I roll through the eight one at a time?

[ranman256]

In a form, you have a list box that shows the people. Select 1 person to print. your query will use this as the criteria to filter.
the query in the list box is select [personID],[name] from tPersons order by Name

the query: qs1PersonRpt uses the list box as the where
select * from tPersons where [personID] = forms!frmRpts!lstBox

the button on the form, frmRpts will open the report that uses this query, qs1PersonRpt
and only report on the item selected in the list

[BatmanMR287]

Sorry, this report is much more advanced than that. I need to print all info at the push of one button. I decided to redesign it to accommodate access.
There is a form that pops up to select district and date. Once you select that it prints all responses to 42 question taken by 8 people. It is a three page report and looks great.

[CJ_London]

It is a three page report and looks great.

Care to share your solution for the benefit of others?

[BatmanMR287]

The report I was trying to emulate had each person's name across the top from left to right with the answers appearing beneath the corresponding person. In the table their names and auto numbers for each person are in a column. As you know access likes to display data in a column vertically not horizontal. So I made the report horizontal with the names on the left side and one underneath the other and the answers running from left to right as well.

They didn't like that format and would prefer it to be in the old format. I would post pictures but I need to populate it with different names to not release real name information. I'm going to post a new question for the solution to this problem with a more accurate title as to the possible solution I am thinking of.