Custom Sorting - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Custom Sorting

Tanya Armstrong

6 years ago

Hi Richard,

I came across an issue today. You may have addressed it in one of your classes but I haven't seen it yet (currently at Expert Class 3).

I made a table for a combobox. The field includes both letters and numbers, field type short text for now. This list contains sections of our vault so we can locate inventory, so they are simple like 1A, 1B, 1C - 11A, 11B, 11C. The sort goes wonky when we reach 10, but because there are letters, I can't change to a number type and because they are locations if I add leading 0s, it might confuse staff looking for things.

Is there a workaround for this?

	Richard Rost @Reply 6 years ago
Not an easy one. The easy one is 01A, 01B, 02A, etc. You could separate the value into two fields in your database for data ENTRY which would make sorting work the way you want, but then concatenate the fields and print them (show them on the screen) without the leading zero.

	Garry Smith @Reply 6 years ago
I would add another field (Number) to the table that would be used just for sorting in the combo box query. It does not need to show in the combo box.

	Richard Rost @Reply 6 years ago
I have to add a way to LIKE Garry's response. :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View