Calculating multiple strings based on Rst entries

[cclambie]

Hi.

I have a recordset with 3 records (variable)
each record has an Operator and a FieldID

Dim strFieldValue As String
Dim strOp As String

The Operator is "*" but could be any other +, -, /

The FieldID is used to pull a FieldValue using a function
fGetFieldValue(strFieldID) as string..

I then concatenate this to a string that looks like
strFieldValue = "1500*0.0012*0"

I need to make this string calculate somehow?

Any ideas?

Or should I approach this a different way maybe? Open for suggestions.

Cheers

Craig

 

[cclambie]

Solved....
Did a test to remove the 0s from the string, then
Concatenated the string into a update query and wullah...had my result.

Thanks!