Due Date (Order Date + 90 Days)

[Brook]

I have an order form in which I have an order date and my
due date is 90 days after the order date. How would I set
this up in my table?

Thanks,

Brook

 

[Allen Browne]

If it is *always* 90 days after the order date, you do not need a field in
your table. Create a query into the table, and in query design view, type
something like this into a fresh column in the Field row:
DueDate: DateAdd("d", 90, [Order Date])

If it is usually 90 days, but you want the user to be able to change it in
some cases, use the AfterUpdate event procedure of the Order Date text box
on your form, to assign the default DueDate date.

More information and example:
Calculated fields
at:
http://allenbrowne.com/casu-14.html