Report Layout Help Required

[David Mitchell]

I have to create a function which cycles through all of the clients
customers, selects any advice notes issued during the period in
question and print of an invoice for each advice note and also a cover
sheet showing each invoice number and the amount and a total balance
owed.

I am struggling to create the report (or should that be reports?) I
already have an invoice report so should I use that and a summary
report or put the invoice report on the summary report as a sub?

Any ideas?

[Larry Linson]

You're likely to be doing this with a Query rather than a "function that
cycles through...". However, with no information on how your tables are
structured, and data is stored, we can't likely give you any worthwhile
advice.

Larry Linson
Microsoft Access MVP

"David Mitchell" <da**************@talk21.com> wrote in message
news:c3**************************@posting.google.c om...

I have to create a function which cycles through all of the clients
customers, selects any advice notes issued during the period in
question and print of an invoice for each advice note and also a cover
sheet showing each invoice number and the amount and a total balance
owed.

I am struggling to create the report (or should that be reports?) I
already have an invoice report so should I use that and a summary
report or put the invoice report on the summary report as a sub?

Any ideas?

[David Mitchell]

Table structure will be fairly standard, tblcustomer (containing
yes/no field - yes for account holder and no for cash sale), one to
many with tblinvoice (containing fields for advice note number,
invoice number, invoice date etc etc) in one to many with
tblinvoicedetail.

My first thoughts were to loop through a recordset of customers who
were account holders and had records in tblinvoice with the advice
note field completed (this is set when a customer is billed, if they
are an account holder they get an advice note which they sign, if they
are not an account holder they get a cash invoice). Each record on
the recordset would then have an invoice printed for each advice note
issued and a summary sheet which would list the invoice number, the
total owed from that invoice, an overall amount sue for the month plus
any balances outstanding from the previous month.

Hope this helps