macsyrinx Posted January 18, 2021 Report Share Posted January 18, 2021 Hi, I am using 'Other' for Facit numbers and in my reports I am wanting to sort by Stamp.CatalogNumber. When I order by Stamp.CatalogNumber, all the numbers with a 1 as the leading digit come before 2. The first stamp listed is Facit 1, then Facit 10, then Facit 1002, and after all 1-leading stamps are listed, Facit 2 is next. When ordering by Stamp.ScottNumber, ordering is numerical. I do notice that if I add leading zeros, the Facit numbers are in order. Is there a way to get Stamp.CatalogNumber to order like Stamp.ScottNumber orders? Quote Link to comment Share on other sites More sharing options...
macsyrinx Posted January 18, 2021 Author Report Share Posted January 18, 2021 Forgot to add this is version 2021 Quote Link to comment Share on other sites More sharing options...
pattrickcolin Posted January 20, 2021 Report Share Posted January 20, 2021 NO. You are trying to sort on a 'Text' field (Scott#). SM stores the Scott Number in two formats within the Access Database. The first format it stores the Full Scott Number as a 'Text' field (this is the field you are trying to Sort on). The second format within the Access Database it stores the Full Scott Number as 3 fields (Prefix, Number & Suffix). It is Number that is a Numeric Field and will sort the way you want. I am uncertain whether the 2nd format can be viewed within the Report you are generating. Hope this helps. Regards colin@colinpattrick.com Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.