Adding two numbers
I think I have asked this question before. I am trying to multiply a quantity field by a cost field to give a total cost. The fields are text as you can only have an integer arithmetic value (and cost and total cost will be a $$.cc format)
Has anyone done something similar. what might the SQL look like?