Calculate a date based on dropdown

[robojeebus]

I have a drop down box in my access database which I want to use to give completion dates to jobs, the drop down has three values:

Emergency
Urgent
Routine

emergency equates to 1 day
Urgent 7days
Routine 28days

I have had a dig in the help files and I can get the order completion date to show the terms emrgency, urgent and routine, however I need to calculate the date, not just show the term, this where I lose track of how to get any further, I have searched the forum and cannot find an example, but perhaps I am not using the right search criteria, I have tried date calculation on drop down results etc etc and no dice, I am sorry if I am posting a question whichg has already been answered, and if anyone can post a link to a solution that would be great to.

Many thanks for your help this is my first post on this forum, but I am sure I will be here for a long tme to come access is fast becoming my life

again many thanks for taking the time to read this and I appreciate any help you can give me.

 

[alastair69]

Do you have the one combox with Emergency, Urgent & Routine and then another with textbox with todays date in and then to finish off with you havea target fix date text box, if can then how is your database set out.

Alastair

 

[robojeebus]

I have exactly as you suggest

Field one is titled priority: this field is the drop down
Field two is Order Date: this is populated with todays date as the order is entered onto the database on the day it is recieved.
Field this is job completion date: this is the field which needs calculating based on the prior two fields.

 

[alastair69]

How are you storing the the value you are going to use against the "Priority"?

Option 1.
Stored in the calulation ie Priority*28. I would not recomment this way as if your options change then you will need to rewrite your code.

Option 2.
A Table with Priority listed and the target fix next to them. This would be profered as you can swop and change your values.

Let me know which way you would like to go and i will help you out.

Alastair

 

[robojeebus]

second way would be preferable as values could indeed change as you say, current drop down is populated by a 1 column table but I guess I can add a column with values.

 

[alastair69]

Can you post your database so i can have a look and give you the best way of doing it.

Alastair

 

[robojeebus]

http://www.vol-ume.com/mhs.mdb

here it is