access 2010 create a report with a filename for each page from a data field
Posted on 2013-11-07
interesting challenge; have a large Access report that creates a unique page for each record.
Would like to create a .pdf of each page in the report with a file name that includes the record ID.
Currently the report is grouped, with ~100 to 200 pages per group (each page break corresponds to a unique record.)
How to create a report that creates >100 unique pages and saves them as individual files, without having to query each record (manually create the single page reports)?