P
Patrick J
I have a dataset that I am using to generate monthly sales reports.
Currently, I am generating one long report that I then export to Word, break
up into individual clients, convert to PDF and then email it out. Because
each month there is a different client set, it is not practical to write
individual reports for each client. The report that I am now using is based
on a query that searches for contracts that are valid that month and returns
any activity on those contracts. I assume that a macro or VBA code could be
written such that a new report is generated each time a new group is
created—could someone help me out on how to do this?
Currently, I am generating one long report that I then export to Word, break
up into individual clients, convert to PDF and then email it out. Because
each month there is a different client set, it is not practical to write
individual reports for each client. The report that I am now using is based
on a query that searches for contracts that are valid that month and returns
any activity on those contracts. I assume that a macro or VBA code could be
written such that a new report is generated each time a new group is
created—could someone help me out on how to do this?