Unanswered: WHEN "Impact" = MED and "reoccurence" = HIGH then "prio" = Importent h
Can somebody help me with a access problem.
I am not very good with access. I looked on Internet but i can't find a solution for my problem.
I am do a update with a ASP web form in a access database.
Now what i want is
When somebody is doing a update in the webform to my Access DB that in access there are automaticly some things done.
In the form they will update 2 columns.
Column 1 = "Impact"
Column 2 = "reoccurence"
The value that will be entered by the WEBFORM will be 4 types of values.
Now i want that access is putting a value in a 3th column.
(this column name is "prio"
WHEN "Impact" = MED and "reoccurence" = HIGH then "prio" = Importent high
How can i do this in access?
Who can help me?
Where do i make this in access?
I don't know access very well.