Jump to content

Report Stamp.CatalogNumber sort


Recommended Posts


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?





Link to comment
Share on other sites

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


Link to comment
Share on other sites

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.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...