Due Date (Order Date + 90 Days)

  • Thread starter Thread starter Brook
  • Start date Start date
B

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
 
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
 
Back
Top