Really basic stuff

[hazell]

I have three fields in my table. One holds numbers 1 to 5 the other holds letters A to E. the third field is empty and I want it to return a calculation based on the other to fields. So, if:

Field 1: 1
Field 2: A

How do I get the query to return the answer 'Very Low' in field C?

Bear in mind there are 25 possible combinations that I would need to be able to put in the table. If you can help can you please put it in really simple terms as I am no expert, as you can probably tell from the question

thanks

 

[pr2-eugin]

Unless you would be able to explain the 25 possibilities, we might not be able to give you the apt answer, but note that it is possible. Why 'Very Low'?

 

[hazell]

It is for a risk assessment. Field a is the risk of offending, field b is the likelihood of offending and field c is the risk - 5 categories - very low, low, medium, high and very high
. So it will be
1 + A very low
1 + b very low
1+c low

up to

5 + e very high

 

[Minty]

If this is a ranking system where 1 or A is low / worst and 5 or E is high / best then you would simply need to assign A-E a value (1 to 5) and then make some criteria to give you your results. It would also depend if the 1-5 value and A-E values have the same 'weighting' ?

Funny how questions lead to more questions . . .

 

[BlueIshDan]

You could create a public function within a module.

Update table set(fld3 = PubFunc(fld1, fld2))

Public Function PubFunc(ByVal fld1 As Integer, ByVal fld2 As String) As String
      ' Code
End Function

 

[hazell]

Its a matrix. We might have a client who is likely to be aggressive but not particularly violent, so we will give them a likelihood of E but a consequence rating of 1. this would make them a medium risk.On paper this works as a grid, with 1 to 5 across and a to e down to give a risk assessment based on likelihood and consequence, both of which are weighted equally.
Not sure whether I have explained this adequately but Ihope you can get the gist of it.