risk analysis matrix

[mdhr]

Hi
i am trying to do risk analysis but not getting further with the matrix.

The matrix looks like:
RISK OCCURANCE RISK LEVEL
low low restriction low
medium medium restriction medium
high high restriction high

depending on the combination of the first two columns, the value on the third column is determined.
In my query, I have drop down list in the first and second column, to make the selection. I want to fill the third column depending on the selection.
I have done this using IF else statements in Excel, but have no idea how to do it in Access.
I hope to find some answers here.

Thank you.

 

[plog]

Can you demonstrate your issue with data? Provide 2 sets:

A. Starting data from your table(s). Include table and field names and enough samples to cover all cases.

B. Expected results of A. Show me what you hope to end up with when you feed the data of A into it.

 

[The_Doc_Man]

Having dealt with risk analysis when I was with the Dept. of Defense, I know that each department has its "rules" on computing risk levels. The methods are standard, more or less, but the results of combining the two inputs can vary depending on management "sensitivity" factors.

What you need to do is first to lay down on paper the equivalent of a "truth" table - a matrix of what level of risk you face for each combination of risk severity and risk frequency. Once you have this filled in, you can perhaps compute the result.

Suppose, for example, you had three levels of risk severity and three levels of risk frequency. You might try an approach that resembles this:

Select Case RiskSeverity
    Case 1
        Select Case RiskFrequency
            Case 1
                FinalRisk = 1
            Case 2
                FinalRisk = 1
            Case 3
                FinalRisk = 2
            End Select
        Case 2
...

You could then make a function that did this, perhaps as a function in a general module that could be called from anywhere that needed the function.

 

[mdhr]

Hi,
Thank for your suggestions.

I have prepared an excel table of my scenario. May be that will make you clear what I want to do.

 

[plog]

No it does not. Please see my first post and provide me what I requested in that.