Community
Showing results for 
Search instead for 
Do you mean 
Reply

Sorting Problem! - Numbers not sorting correctly

Accepted Solution Solved
New Member
Posts: 2
Country: United States
Accepted Solution

Sorting Problem! - Numbers not sorting correctly

Hi
I am pulling in exhibitors from Excel spreadsheets for trade shows and am having a problem with one particular issue.  I have the booth sizes for each exhibitor.  This is a major factor and I need to be able to sort on booth size.  What it does is sort on the first number only.  So, 17,000 ends up before 9,000.  It does sort within each numerical category.  So 1,700 ends up before 17,000.

 

Is there a way to modify the sort preferences for this function?  This is my ACT! version:

 

ACT! by Sage 2006 Version 8.0.2.82

 

Thanks,

Jim


Accepted Solutions
Solution
Accepted by topic author jminter
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Sorting Problem! - Numbers not sorting correctly

The field is a character field and they are sorting correct for a character field. For what you want it need to be a number field.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129

View solution in original post


All Replies
Solution
Accepted by topic author jminter
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Sorting Problem! - Numbers not sorting correctly

The field is a character field and they are sorting correct for a character field. For what you want it need to be a number field.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
New Member
Posts: 2
Country: United States

Re: Sorting Problem! - Numbers not sorting correctly

Thanks Roy,

Whoops. I thought I did that when creating it.  Is it possible to change the type without wiping out the current information?

Thanks,

Jim

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Sorting Problem! - Numbers not sorting correctly

Best to create another field with numeric data type and copy into that field. That way you can check to see if the it copied correct. If so, then change the data type on the first field and copy the converted information back.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129