Community
Showing results for 
Search instead for 
Do you mean 
Reply

How To Search On A Text Field With Numbers

Bronze Contributor
Posts: 1,428
Country: USA

How To Search On A Text Field With Numbers

ACT 2010 SP1

 

I have created a text field that contains mostly numbers, but I wanted a text field because it might show the number of employees as "1,000 => 850" meaning that they would be downsizing.  Another would be "1,000=650 @ HQ and 350 @ Branches"

 

Is there a way to logically do a lookup that would treat this field as a number lookup?

John Purdy
ACT! Premium V. 18
Lenovo X220, 16GB, & Office 365, 32bit, 256GB SSD