Solved

# Data Merging

Posted on 2003-03-03

Hi there

I'm trying to do some calculations on some data in a SQL database. I have a formula in a text field of the form a/b or a*b/c etc

the figures to be subitituted are in another table referenced against the relavent letter.

I need to save the calculated figure in another table.

The way i thaught about going about this is to substitute the figures into the formula, and then do the calculation.

I'm not quite sure how to put this into action.

Any help would be greatly appreciated.

thanks

Gareth