Add Months to a Date in Access 2007

[tgeorges1123]

I need to add a number of months (entered into a field as "Term (Months)" and set as a number) to a date field to derive a new date field. For example:

Field 1 Move-In Date: 3/1/2014
Field 2 Term (Months): 60
Field 3 Lease Expiration: 2/28/2019 (this is the date I'm trying to calculate)

Thanks for your help. I am a total Access n00b and am building a comp database from scratch for the CRE firm I work for. I have managed to successfully do everything except this. :)

[zmbd]

I'll PM you a set of links and tools that you should find helpfull.

As for the calculation, normally one does not store calculated results; thus, in your case, in the table, store the move_in date and the term (ie: 36 months)

Now in a query, add your table, select the correct fields and then use the dateadd() (ACC2007/2010) function in a calculated field (Allen Browne)

If you have any difficulties in accomplishing this please let us know, and check you Bytes inbox (^_^)

[Seth Schrock]

The function that does this is the DateAdd() function.

DateAdd("m", 60, #3/1/14#) = 3/1/2019
DateAdd("d", -1, #3/1/19#) = 2/28/2019 

However, there are multiple ways of implementing this (in a query, in the form, etc.). As it would break Database Normalization Rules to store a calculated field, it would probably be best done in a query, but that depends on the situation and preference.

Since you are new to Access, I would highly recommend reading through the database normalization link above as it will help you keep problems at bay and make it easier to build upon in the future if necessary.

[zmbd]

Looks like I cross posted with you Seth, right at 4 minutes on the posting times (^_^)

[Seth Schrock]

Great minds think alike :)