convert text to number

R

Rob

I need to convert fields in a query that are text to
numbers. Is there any way to do this? The data are
numbers but are in text format.

Thanks,
Rob
 
F

fredg

I need to convert fields in a query that are text to
numbers. Is there any way to do this? The data are
numbers but are in text format.

Thanks,
Rob
Click to expand...

Exp:Val([FieldName])
 
R

Rob

Thanks!

-----Original Message-----
I need to convert fields in a query that are text to
numbers. Is there any way to do this? The data are
numbers but are in text format.

Thanks,
Rob
Click to expand...

Exp:Val([FieldName])
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Top