I would execute the sql and just get the original value. THEN, do your conversion; i.e., do the VAL(FIELD_NAME) later. If you are populating a grid, do the conversion as you cycle through the recordset, rather than WHEN you get the recordset.

HTH