SQL query to update MS Access table column partially

Posted by Shivnaik under Sql Server on 5/12/2011 | Points: 10 | Views : 1725 | Status : [Member] | Replies : 2
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




Responses

Posted by: Udip on: 5/14/2011 [Member] Starter | Points: 25

Up
0
Down
You may find this SQL UPDATE Tutorial of w3resource.com useful.

Shivnaik, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Shivnaik on: 5/15/2011 [Member] Starter | Points: 25

Up
0
Down
Thank you Udip, for the reply. I did a string replacement with nesting the loops with the query.

Shivnaik, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response