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
Click to expand...

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
Click to expand...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Re: Convert Number to Text and keep leading zeroes 1
Numeric Field Overflow when appending date - how to convert it to text 1
Convert Text to number 8
number in criteria changing to text 4
Number fields being converted to text 6
Convert week "number" to actual number to sort it in column headin 2
Convert a Number data type to Text using a query 3
Convert number to text 1

Back
Top