Look at the DateAdd function.
May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us ----- Original Message ---- From: hvadney <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, October 19, 2006 5:16:30 PM Subject: [ms_access] Date Plus Hello, Everyone! I am creating a database in which I have to enter document data. For example: Date Sent, Date Received (by recipient), Date Required, etc. I would like to put the date a document is received by the client in one field and have access take that date and calculate a "Due Date" in another filed "Due Date" by adding 21 days to the "Received Date" field and entering the calculated date in the "Due Date" field. For example: I have to send out lists of questions to a recipient on "Date Sent" and the Recipient receives the list on "Date Recd" and must have the answers back on my desk 21 days (20 days after receipt, exclusive of the day of receipt). A useful variation would be to enter the date in the "Date Received" field, the number of days allowed for response in another "Days Field" and then tell Access to take the "Date Received" date, add the number of days entered in the "Days" Field and then enter the calculated date in the "Due Date" field. How do I get Access to do this for me? Thanks very much in advance! Harold [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ms_access/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
