Saturday, November 24, 2007

Using Queries to Convert Text Fields to Numerics

Using Queries to Convert Text Fields to Numerics: "Using Queries to Convert Text Fields to Numerics"


CDbl("3.2") =3.2

CDbl([MyField]) -->>>If MyField contains "3.2", 3.2If MyField contains "ABCD", a Type Mismatch error occurs

No comments: