Add a number of days to a date in access

[Guest]

i need help in adding "number of days" and "hiredate"(current day the movie
is borrowed), so that i can get the Duedate to display in the text box once i
click on the command button.

 

[Dirk Goldgar]

i need help in adding "number of days" and "hiredate"(current day the
movie is borrowed), so that i can get the Duedate to display in the
text box once i click on the command button.

Use the DateAdd function. You'll find it in the online help. If
DueDate is entirely dependent on [Number of Days] and [HireDate] -- and
both those values are saved -- you don't really need to save the
calculated value. Just create a calculated control on your form with a
controlsource expression like this:

=DateAdd("d", [Number of Days], [HireDate])

Naturally, you'll have to replace "Number of Days" and "HireDate" with
the names of your own fields, if they are different.