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...