dluhopCopper ContributorAug 18, 2022Key Field Question I'm trying to create a database with a key field containing 1a, 1b, 2a, 2b, 2c, etc. If I make this a text field it does not sort properly. Is there a way to do this? Thanks for your help. Show More
arnel_gpSteel Contributor to dluhopwithout Splitting your field, you can sort on:ORDER BY Val([FieldName]), Right([FieldName],1);
dluhopCopper Contributor to arnel_gpAug 19, 2022I don't know where to put this expression. Can you be more specific? I appreciate your help.
