If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Due Date (Order Date + 90 Days)
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 |
#2
|
|||
|
|||
Due Date (Order Date + 90 Days)
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 -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Brook" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to calculate days:Hours:Minutes: | Kurewe | Worksheet Functions | 46 | January 17th, 2005 11:11 AM |
set query date criteria to show record 8 days after entry | garry | Running & Setting Up Queries | 1 | July 20th, 2004 01:55 PM |
Adding Business Days to Date | Dan R. | Worksheet Functions | 3 | May 17th, 2004 04:52 PM |
CALCULATE FUTURE DATES | Michael J. Malinsky | Worksheet Functions | 5 | February 5th, 2004 04:42 PM |