Community
Showing results for 
Search instead for 
Do you mean 
Reply

How To Search On A Text Field With Numbers

Bronze Contributor
Posts: 1,394
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 2016 (V. 18)
Dell XPS Ultrabook with 4GB, Win 10 Pro, & Office 365, 32bit