10-05-2011 10:19 AM
ACT is currently organizing the fields when numbers are involved for ascending or descending order (e.g. Suite 150 is showing after Suite 1000) when creating a lookup. This also happens under the groups tabs where we have Groups labeled off of addresses. Is it possible to have the lookup based on actual increasing numberical order versus going one number at a time to determine the order?
10-05-2011 11:18 AM
Not in alphanumeric fields. Numbers in an alphanumeric field are sorted from left to right thus every number that started with 1 would sort before a number starting with 2. For an alphanumeric field to sort in numeric order, all the numbers must have the same number of digits. For example a ZIP or post code field will sort in numeric order because each ZIP code starts with 5-digits.
10-05-2011 11:25 AM
10-05-2011 11:30 AM
That is correct about numeric fields. As to the report, it would depend on how you designed the report.