Formatting field to express months

[sgarfunkel]

The form I am creating needs to be able to generate a report that gives me expiration dates on contracts which I have entered a start date. The form was originally created using a number for years instead and we can go as low as 6 months to an odd number like 35 months for the length of contract. Ex: It's calculating 35 for years instead of months. Is it possible to format a field so that it can calculate by number of months?



So basically I need it to give me #length of contract x start date=expiration date

[June7]

Use DateAdd function to calculate date for units other than day.

expiration date = DateAdd("m",[length],[start date])

Day is default unit so can be simply: [start date] + 5

Use DateAdd to calculate with other time period units.

There are other date and time functions you might find useful. Search Access Help or web.