Change date after printing report

[dutyfree]

Hi, I've set up a report which displays when a service is due on a certain month.

I have been asked if I can automatically update the date of the displayed fieldsby a year after the report has been printed.



e.g. if the report shows a service is due on 22/10/11, then after the report has been printed the date will be updated to 22/10/12.

Is this possible to do on just the records displayed on the report, without changing every record in the table?

Thanks for any help

[alansidman]

You can do this with an update query.

Here is a quick tutorial on how to do an update query

http://www.youtube.com/watch?v=nFH0be4uG64

Alan

crosspost

http://www.access-programmers.co.uk/...te=1&p=1106885

[dutyfree]

Okay so how do I implement this to add a year to the date, no matter what the year is? It's important to leave the customer alone with this so they don't have to keep coming back to me asking to renew their service dates.

Thanks

[alansidman]

You will probably need to implement some VBA code. How are you running your reports now? You probably need to incorporate the update query into the end of the code you are running for the report. You will need to incorporate the DateAdd function to make it automatically update the year.

Alan

[dutyfree]

The report is running off a simple parameter query right now, where would I add in the dateadd function?