Sorting Fields
Sorting Fields
(OP)
I have several tables that have the same primary key which is called CaseNum and is a text field. The data in this field is contains mostly numeric entries, however there are a few entries that contain letters(i.e. 1,2,2a,3,3a...)I want to be able to view these in order (from case 1 to Case 30)but I am having trouble doing it. Is there a way to sort text data so that it will be in order from 1 to 30 (not 1,10,11,12...2,20,21,22...)that will also recoginize that 14 and 14a should be in that order?
Thanks
Thanks
RE: Sorting Fields
Can you split your field into two fields, maybe CaseNum and CaseLetter? However, to make the combination of the two fields a primary key, you have to have text in both fields, so that CaseLetter would have to contain _something_, maybe a space?
Another option is to create a table that only contains two fields, CaseNum and SortOrder. You could create a form to maintain the sort order (it would require some coding). Then any time you want to sort, include this new table in a query and sort on SortOrder.
Just some ideas. Hope this helps.
Kathryn
RE: Sorting Fields
RE: Sorting Fields
Thanks for the suggestions. Since my Access skills are fairly simplistic, I decided to go the easy road. Instead of trying to split the fields, I just changed the numbering system to numeric decimal and am using .1,.2,.3 instead of a,b,c. I think that should work (Hopefully)
Thanks again for the help.
Jason
RE: Sorting Fields