Reporting

[andream02]

Hello! I have a report that I've created in Access using a crosstab query. In the query I have a series of projects that are coded with a unique ID. I'm happy with the layout of the report, however, I want Access to generate the same report for each individual project ID. I have about 40 different project IDs that need their own report - thus 40 different reports. Would anyone be able to help me with the macro or SQL code to achieve this result?

Thanks!

 

[Norie]

How is the report currently laid out?