calculating due dates in access

[trixxnixon]

Hi all,

I have been handed a new project that required me to update a database... a rather complicated database. I take that back, its not that it is super complicated, I am just a novice user and not a programmer.

The biggest change that I have to make is to create a form with a drop down menu
that has a list of request types, a drop down menu of priority levels.
The priority level drop down menu will have to display a set of 3 priority levels unique to the request type. These priority levels will have a value of "due in # of business days"


For example if
Request type selected: Manual Revision

Priority level:
Critical: 1 business days
Urgent: 3 business days
Standard: 15 business days


Then the priority level drop down menu would populate with three unique values that.
The priority level options would change each time the request type would change.


When the priority level is selected the due date would be calculated based on the current date + 15 working days omitting weekends. The due date would display in a field called “Due Date”


Is this something that is super complicated or is this easy? I am a complete novice and am in dire need of help. If anyone can help me complete this task, please let me know.


Thank you all for your time.

 

[CyberLynx]

Basically all you are to create is a Search Form which should contain a Combo Box Control so as to select the desired Priority Level, a Text Box to display the Calculated Due Business Date, and a SubForm (in DataSheet or Continuous format) to display the Records found matching the desired Date criteria. Only business days are to be taken into account (not weekends and perhaps no Statutory Holidays).

This is not difficult do but not so easy to explain. It also opens a window to an unknown number of questions some of which you may not be able to answer at this point.

I would suggest you create a small sample Database based on the current tables you are using with some fictional data and post it here. I will be more than happy to create this Form for you and explain within it the processes involved to carry out the task.

Let's see what you've got so far.

.

 

[trixxnixon]

i figured that the database i am updating does not require the corresponding drop down menus as each request type has its own form.........

the bad part about this database, is everything is contained in 1 table... over 100 different fields, all the forms update the same table, all i really need to do now is create unique “priorities” table for each request.

The tricky part is the due date function thing, that calculates a due date, based on the priority(# of business days past the current date, omitting weekends)






im about to make a sample and upload it.