Access Newbie - Add and display 1 year after date

[Snaphaan]

Hi



I am trying to help my folks streamline their business a bit more by getting them off Q&A and on to access. It's a small publishing business with a monthly newsletter. Access and database set-ups is not really my field but I'm going to give it a as much of my time as I can. I've gone through a number of tutorials and most of it is reasonably digestible but I think I have stumbled upon a hurdle.

The newsletter is a yearly paid-subscription and I need to be able to put up a sort of query/reminder of which subscribers need to renew. So that means I need to add 1 year to the subscribe date. After a bit of Googling I found a lot of DateAdd() function references for a similar problem but nothing really explaining how or where to implement it.

DateAdd("m", 12, [DateLastCalibrated])

I assume the [DateLastCalibrated] should be able to be replaced with my subscribed date but I get a number of invalid errors. Does it have to be implemented as a query? Should I create a calculate field? Do I even need to use this!?

I would appreciate a nudging in any direction. Something I first need to get my head around maybe. Or maybe I'm WAY in over my head!

Thanks for your time!!

[JoeM]

I like to do most of my calculations in a query (as opposed to directly on a report) whenever possible. Then use the query as the source of your report.

Make sure that you date field is actually stored as a Date Type and not Text in order for it to work properly.

[jzwp11]

The newsletter is a yearly paid-subscription and I need to be able to put up a sort of query/reminder of which subscribers need to renew. So that means I need to add 1 year to the subscribe date.

The dateadd() function would generally be the best approach but let's say that a person subscribes on 10/5/2010 and then they renew on 10/6/2011. It is now 2012 so if you add 12 months to the original subscription date you will get 10/5/2011 which will not help you. How are you recording each renewal?