Hello Everyone and Thank you in advance!!!

I need to create a field or query that will calculate the due date of a document.
Example I completed this for and its due in 10 working days.
So from the date originated field [Date] and due date is [Due Date]
How to have access calculate 10 working days from the originated date.

Thank you

1. Rename your field DATE to something else. That is an Access Reserved word and is one that it really gets sticky if you continue to use as a field name.

2. You can use the DateAdd function to get the due date in a query. (the syntax is here on the site and in the help file). (EDIT - SEE RG's Post below for a more appropriate answer to this part)


http://downloads.btabdevelopment.com/screenshots/welcometoawf.png

Search this site for Workday.

Hi -

Take a look at http://www.access-programmers.co.uk/forums/showthread.php?t=159719&highlight=upbusdays3 Post #3.

HTH - Bob