Hi,
I have a report which shows all my customers and the totaled amount
they have paid in the previous year. It prints about 12 customers in
landscape format per page, however I want just one customers details per
page so that I can send them a year end statment for each individuals
account. How can I achieve this with Access 2003. Tia, John
Wolfgang Kais - 29 Jul 2005 12:25 GMT
Hello John.
> I have a report which shows all my customers and the totaled amount
> they have paid in the previous year. It prints about 12 customers in
> landscape format per page, however I want just one customers details
> per page so that I can send them a year end statment for each
> individuals account. How can I achieve this with Access 2003.
I hope you have a group header for something like CustomerID.
In the properties window of that section, set the ForceNewPage
property to "before section".

Signature
Regards,
Wolfgang
John - 30 Jul 2005 12:54 GMT
That worked great Wolfgang tvm, but how can I get the header details to
print on each page, stuff like the logo,company name,etc.At present it is
displayed on only the first page and all the others dont show those details.
> Hi,
> I have a report which shows all my customers and the totaled amount
> they have paid in the previous year. It prints about 12 customers in
> landscape format per page, however I want just one customers details per
> page so that I can send them a year end statment for each individuals
> account. How can I achieve this with Access 2003. Tia, John
John - 30 Jul 2005 23:48 GMT
> That worked great Wolfgang tvm, but how can I get the header details to
> print on each page, stuff like the logo,company name,etc.At present it is
[quoted text clipped - 6 lines]
>> page so that I can send them a year end statment for each individuals
>> account. How can I achieve this with Access 2003. Tia, John