Split one report to many

[JasonRkr]

Hi, all. Is there a way to have one report save off as many? I have a report that contains information on approximately 26,000 members. I need to break each member's data into its own report.

Thanks.

Jason

 

[vbaInet]

You could create a group for each member's Id by using the Sorting and Grouping functionality on a report, here's a link:

http://office.microsoft.com/en-us/a...ds-together-on-a-report-page-HP005187363.aspx

Once that's set up click on the group's Footer section and set its Force New Page property to After Section.

 

[JasonRkr]

vbaInet,

Thanks for the quick response. Is there a way to then get each individual group saved off to its own file?

Jason

 

[vbaInet]

In that case you would need to program it to do so. Create a recordset to get the individual groups and loop through whilst using Docmd.OutputTo command if you're using Access 2007 or 2010.