Hi,
I'm trying to make small but I'm stuck here.
I need some kind of solution in Access that will search through table and give me back a value.
In attached picture (No.6 ) 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 with combination 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 thinking of making some VBA code with 3 variables.
If this is the right way to go, can some one advice me how to do it, while I'm complete novice in Access.
Thanks in advance
Sparky23
I'm trying to make small but I'm stuck here.
I need some kind of solution in Access that will search through table and give me back a value.
In attached picture (No.6 ) 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 with combination 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 thinking of making some VBA code with 3 variables.
If this is the right way to go, can some one advice me how to do it, while I'm complete novice in Access.
Thanks in advance
Sparky23