Automatic Due Date Calculation?

[mrjane]

This may be easy, but I haven't been able to find out how to do it anywhere on the internet.



I'm looking for a way to make one of my fields auto-calculate a due date. I have a field for "RentalDate" and when I fill this is, is it possible to have the next field (DueDate) automatically enter a date that's 10 days later?

Any help would be appreciated. Thank you.

[JoeM]

If DueDate is always a function of another date, it should NOT be stored in a table field. Anything that can be calculated should not be stored.
Simply perform the calculation in a query (and use that query as the Data Source of your Form/Report), or do the calculation in a calculated field right on the Form/Report.

[ranman256]

due date :
=DateAdd("d",10,txtRentDate)

[JoeM]

Or since dates are stored in Access in terms of days, simply:

[RentDateField] + 10

[mrjane]

Worked perfectly! Thanks.