[MS_AccessPros] convert text field to number

 

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: pattykf@cox.net

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___