export multiple reports based on table records

[steve2000]

I really hope my problem will be a piece of cake for an expert coder.

I have this table with around 60 records but it will grow overtime. I need to export 60 individual reports (or how many records will be in the table).
I have attached an example of what I’m trying to do.


The table is called “Tzone” and the report “Rzone”. I want to export in snapshot. I want to export a report for each zone (and be able to do it for each state).
I have a form to export the report, but don’t know how to do it automatically to export all the reports separately.
Any help will be appreciated.

Steve

[Access_Blaster]

I really hope my problem will be a piece of cake for an expert coder.

I have this table with around 60 records but it will grow overtime. I need to export 60 individual reports (or how many records will be in the table).
I have attached an example of what I’m trying to do.
The table is called “Tzone” and the report “Rzone”. I want to export in snapshot. I want to export a report for each zone (and be able to do it for each state).
I have a form to export the report, but don’t know how to do it automatically to export all the reports separately.
Any help will be appreciated.

Steve

I don't know about printing out a bunch of seperate reports, I grouped and sorted per your request. I also used a macro to output to a snp file. I only did the state example. You can tweak it to suit your needs.

Richard

[steve2000]

Thank you for your response. I guess I wasn't too explicit on my initial message. What I like to have is export a separate report for each record. In the case I have 20 states on my table, I should have 20 reports.

Appreciate your help.

[Access_Blaster]

Steve see if this is closer to what you need.