What is the best way?

  • Thread starter Thread starter josie
  • Start date Start date
J

josie

Using access 2002 for a small business. At the end of each month we run a
report which lists all debtors and debt. Would like to be able to click on a
button and what would be produced is a statement for each of the listed
debtor.

any suggestions / sample code as to the best way to do this would be
appreciated

thanks in advance

josie
 
You're going to need to give more info than that.
What you're asking for is an entire application...

I'm sure people will be willing to help,
but give more specific info like table names, fields, etc..

Thanks


Joe
 
The statement needs to be a report so create that report. Create a form
based on the same query as your report to list the debtors and debt. Put two
buttons on the form; the first prints your current report the second prints
your statements.
 
Thanks for your input

what sort of code would be needed to do a print run of all statements as a
batch?


tia
josie
 
You need a report that is designed to be a statement. Base the report on
your query that lists the debts and debtors.Put a page break at the end of
the report. You will get a batch report with a page break after each debtor.
 
Back
Top