I have got two fields one contains numeric data and the other contains text both the fields are from a query, the text field has data i.e. either "A" or "B", Now I want to multiply Numeric field with text field (Where A='###' and B='####') and get the result in new field .
[in my table text field has only A and B it doesn't have the values that A and B should contain]
Name Value Text Result qwert 12,02 A gfdhug 32,02 A vgsuid 45,01 A dfjhis 78,201 B fgjog 456,0213 A goofgfhd 1,045 B where A= 145 and B= 150