I got the previous code to work. Thanks!!...one thing I would like to change is that right now it automatically sends the report to the printer. I would like to preview the report and then print it myself. If I add acViewPreview it only brings up the first report then stops. Any thoughts?
Yes, a recordset is what I want to do. I have done it years ago but couldn't remember what it was called and how to do it. My table is tblPayroll with fields client, invoice amount, etc.. and the report is rptPayroll. Thank you!!
Thanks for the reply but I would like to avoid picking by client but rather have them all be created at once but each client on a new report. Does that make sense?
I have a query that contains multiple clients and then number of employees per client. What I want to do is create an invoice per client using the one query but can't figure out what to do. Right now it puts all of them on one report but I want seperate reports per client. Help!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.