Showing results for 
Search instead for 
Do you mean 

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,753
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