Hi Everyone,
I am working on ms access DB. I have never used this before. But I have worked on SQl.
I have a table in ms access with one column having the mathematical expressions like below
a0+(b0/a01)
a^2+b^2
I have one more master table specifying the values for the constants like below
a0 2
b0 3
a01 6
I have to update the expression and replace the constants in the expressions with the values in the master table.
Ex: The expression a0+(b0/a01) has to be updated as 2+(3/6). i.e. a0 is replaced with its corresponding value 2 and b0 with 3 and
a01 with 6.
Please help me how I can do this. I have to write the SQL query to update this in MS Access 2000.
Thanks in advance