Hi,
I'm trying to make small but I'm stuck here :banghead:
I need some kind of solutions in Access that will search through table and give me back a value.
In attached picture there are 3 columns.
when I give two variables exp (AA2) and (AA1), Access should find the row in the table where AA1 and AA2 are stored and
give me back the value from the third column (in this scenario 0.6).
Note that variable should be text
and the row for with AA1 and AA2 is unique. There is no AA2 and AA1 row.
So the solution should actually compare both columns with both variables.
I'm not allowed to attache the pictures so here is a short sketch:
AA1 | AA2 | 0.6
AA1 | AA3 | 1.2
AA1 | AA4 | 1.9
AA2 | AA3 | 0.6
AA2 | AA3 | 1.4
and so on
Thanks in advance
Sparky23
I'm trying to make small but I'm stuck here :banghead:
I need some kind of solutions in Access that will search through table and give me back a value.
In attached picture there are 3 columns.
when I give two variables exp (AA2) and (AA1), Access should find the row in the table where AA1 and AA2 are stored and
give me back the value from the third column (in this scenario 0.6).
Note that variable should be text
and the row for with AA1 and AA2 is unique. There is no AA2 and AA1 row.
So the solution should actually compare both columns with both variables.
I'm not allowed to attache the pictures so here is a short sketch:
AA1 | AA2 | 0.6
AA1 | AA3 | 1.2
AA1 | AA4 | 1.9
AA2 | AA3 | 0.6
AA2 | AA3 | 1.4
and so on
Thanks in advance
Sparky23