Community
Showing results for 
Search instead for 
Do you mean 
Reply

Group Criteria

New Member
Posts: 1
Country: United States

Group Criteria

In formulating group criteria how do I create a value that is larger than 10?  For instance, I want a group to sort by Number of employees greater than or equal to 10 but less than 50.  When I have put this string into the criteria I am getting only companies with less than 5 employees.  Is there a way for ACT! to read the "0" after the 5 in my command?

Platinum Elite Contributor
Posts: 6,651
Country: USA

Re: Group Criteria

I suspect that the field that you are setting the query on is a character field and not a number field and, in most cases, a range lookup can;t be done on a character field.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129