beginner needs some help.

[mattyj]

I am building a database for my father and he wants it to calculate the expiry date on warranties. I can do it if I make 3 separate fields like "day" "month" "Year" because the warranty date is 1,2,3 years ahead so I can just make the year change by the number of years.

But,,,, I have all the data entered using the drop down date function, how would I get it to change the year by 1 2 or 3 years using the drop down window for date and number of years for the warranty?

[Lee Smith]

Warranty Expiration =

Date(Month( StartDate); Day ( StartDate); Year (StartDate)+Term)

StartDate is the date you wrote the warranty, and Term is the field where you have entered the 1, 2, 3.

HTH

Lee