Having trouble getting report to work.

[jukus]

I have a table with peoples information and a yes/no check box for volunteer, and then a table for items with a person id. The 2 tables are linked under person id. person table has person id as primary key and items has person id as a field in the table. I am creating a report that will pull information on the 2 tables. I can create a query to pull info based on the check box. Problem I am havinng is getting the report to generate one report for each person id. My question is how can this be done, or is there code you can enter in the events that will only pull records based on check box. I am using Access 2007.. TIA for any ideas or help.

 

[Kryst51]

I don't know about a different report for each one. But if you do a grouping by Person ID, and then for your headers, repeat section. You should be able to force to next page on the Person ID grouping which would at least put each one of those on a new page.

 

[jukus]

Thanks. That will work. It gives me a new page for each id.

 

[Kryst51]

Great! I'm glad I could help.