Printing dates

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Hi

I have a report that prints multiple invoices for each student in my table
depending on the number of monthly payments they chose. The problem is the
date on each invoice is always the same! One field in the table has the
first payment date. I want the other payment dates to be increased by one
month each.

E.g. the payment date on the first invoice is January 15, on the second
invoice
it's February 15, on the third it's March 15... etc. Each student has a
different payment date and different amount of payments, so the date routine
has to be automatic instead of specified.

How can I do this automatically when the report is compiled?

Thanks for any advice

Jeff
 
Hi Jeff
The basic approch could be:
Month([Date#])+page & "/" & Day([Date#]) & "/" & Year
([Date#])
This assumes that each invoice is printed on a new page
Hope tis helps
Fons
 
Back
Top