Printing dates

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
 
F

Fons Ponsioen

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top