I'm using MS Access 2010 and have a user that needs an existing report split out into separate pdfs by department.
I have a report set up using an existing query to group and sort the data by department. My question is, how can I print it to acrobat as separate files for each page of the report. I spent a lot of time googling it yesterday and saw several suggestions about building filters then using a bunch of VBA to do split the report out.
Is there an easy way to do this without a lot of coding and filtering? Thanks.
Here is the SQL code:
SELECT tblSpecIssue.EventNumber, qryConfidentialModule.DateOfEvent, tblSpecIssue.ReviewNo, subtblDepartments.Department, tblSpecIssue.DateSent, tblSpecIssue.DateReceived, tblSpecIssue.PractionerPerformanceIssue, tblSpecIssue.[Provider #], subtblPhysicians.Title, [subtblPhysicians].[LastName] & ", "+[subtblPhysicians].[FirstName] AS Fullname, subtblLocation.Location, tblSpecIssue.Prov2, tblSpecIssue.Prov3, tblSpecIssue.Prov4
FROM (((subtblPhysicians RIGHT JOIN tblSpecIssue ON subtblPhysicians.[Provider #] = tblSpecIssue.[Provider #]) LEFT JOIN subtblLocation ON subtblPhysicians.LocCode = subtblLocation.LocCode) LEFT JOIN subtblDepartments ON subtblPhysicians.DeptCode = subtblDepartments.DeptCode) LEFT JOIN qryConfidentialModule ON tblSpecIssue.EventNumber = qryConfidentialModule.EventNumber
WHERE (((tblSpecIssue.PractionerPerformanceIssue)>"0"))
ORDER BY tblSpecIssue.EventNumber, tblSpecIssue.ReviewNo;
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar