Hi,
I've got a project dealing with various Decision Making Algorithms.
Wondering the VBA code of ;
Selecting the MAX. value from a table that has 1 record, which has 12 user-input (integer) attributes .
ex: Table tblWgtFactors >
Var1 Var2 Var3 Var4 Var5 Var6 Var7 Var8 Var9 Var10 Var11 Var12
------------------------------------------------------------------------------------
4 3 6 4 2 3 3 1 2 3 4 5
this VBA code should return value <6> , and put it in a new table tblMax_weight
PS : ( i've tried to solve it by Linking Excel <---> Access , but having Update problems ,, )
Thnx,,
I've got a project dealing with various Decision Making Algorithms.
Wondering the VBA code of ;
Selecting the MAX. value from a table that has 1 record, which has 12 user-input (integer) attributes .
ex: Table tblWgtFactors >
Var1 Var2 Var3 Var4 Var5 Var6 Var7 Var8 Var9 Var10 Var11 Var12
------------------------------------------------------------------------------------
4 3 6 4 2 3 3 1 2 3 4 5
this VBA code should return value <6> , and put it in a new table tblMax_weight

PS : ( i've tried to solve it by Linking Excel <---> Access , but having Update problems ,, )
Thnx,,