I have a database that contains a list of over 300 solutions to a set of
approximately 180 problems. I created a form that allows me to select a
specific solution (via combo box) and this form is tied to a query that will
pull open a pivot table that displays that solution and all other solutions
related to the problem they are tied too.

Given that, I have created a report based on the pivot table output but
would like to be able to somehow automate the report generation process so I
don't have to select all 300 solutions individually, but rather have a Macro
select all 300 and create the subsequent report for each.

Is this asking too much of Access 07 or does it seem feasible? Thanks.

Klaus