coneverting the datatype

[sam536]

Hi,

my table have a a text field F1 (data ex:25%) and number field F2 . I have a query which contains a new number field based on the above fields i.e F3=F1*F2.My query is not able to retrieve the data.My data is been filled with error#.How i can convert the data types in order to get the multiplication of those two fields.

Thanks in adavance

sam

 

[WayneRyan]

Sam,

New column in your query:

F3: CDbl(Replace([F1],"%","")) * [F2] * 0.01

hth,
Wayne