Patty
Depending on what the numbers are (integers or decimals) all you have to do in most cases is use a built-in function to convert it. Whole numbers like "968" would use CLng or CInt like this:
CLng([myTextNum])
So would be true: CLng("002") < CLng("3")
Decimals would use CDec()
Or are you talking about text like "one hundred"?
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
---In MS_Access_Professionals@yahoogroups.com, <pattykf@cox.net> wrote :
I have a field that the table unfortunately has numbers in text format
I did a search on converting but just can't find a reasonable answer on how to convert it to text. I am sure there is a simple conversion but I can't find it
I eventually want to be able to query the data for less and greater than values so I need it in number format
thank you
Patty
__._,_.___
Posted by: wrmosca@comcast.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar