dragonlight
Thread Starter
- Joined
- May 30, 2002
- Messages
- 347
I have an access form, I have three fields in this form.
"Warranty Start Date" ( I type in the date when the item was sold.
"Warranty Length" (This is how many years the warranty is) (normally "3yrs"
"Warranty Status" ( I have this formated so that if it's in warranty, the color is green, out of warranty, it's red.)
What I would like to do is; manually enter the date in Warranty start date, then have warranty length defaulted to 3yrs (already have that), then an equation that would take the warranty start date, add 3yrs to it and auto place it into the warranty status field.
Any help would be great.
"Warranty Start Date" ( I type in the date when the item was sold.
"Warranty Length" (This is how many years the warranty is) (normally "3yrs"
"Warranty Status" ( I have this formated so that if it's in warranty, the color is green, out of warranty, it's red.)
What I would like to do is; manually enter the date in Warranty start date, then have warranty length defaulted to 3yrs (already have that), then an equation that would take the warranty start date, add 3yrs to it and auto place it into the warranty status field.
Any help would be great.