convert text to number

  • Thread starter Thread starter Rob
  • Start date Start date
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
 
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

Exp:Val([FieldName])
 
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

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