SQL to convert string to number

[ciarra41]

I've been trying to convert a text value into an integer and/or a number value.
Here's the syntax:
SELECT CInt([tblme.Lotphone]) AS Unitnum, tblme.custID
FROM tblme;
I'm getting the overflow error. Could someone advise me of a revision!

Many Thanks!!

 

[jrbarnett]

What's the range of numbers in the Lotphone field? (theoretical largest and smallest)

John

 

[ciarra41]

Their all 10 digits long.
example:9145444747

 

[dhookom]

9,145,444,747 can't be expressed as an integer. Consider using CLng() or CDbl() or Val(). Check Help on specifications if you have questions.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]