Sorting Order

[Antonio]

I have a Access database used by several users. Unique, 6
digit numbers are entered into the database and print out
on various reports for various reasons. The we sort the 6
digit numbers (each number corresponds to a patient and
his/her medical chart) in a unique way. Is there a way to
specify the sort order for numbers entered into an access
database?
Example: MR # 567891 is phsically filed by the last two
digits, then the middle two digits, and finally the first
two digits.
So...for sorting purposes it would be nice if you could
tell access to sort like this: 56 78 91
3 2 1
To make it work, I have had to break each 6 digit MR
number into 3 individual, 2 digit, fields and place them
right next to each other on all forms. Then I sort by the
last two digits only...
I appreciate any help.

 

[John Vinson]

Example: MR # 567891 is phsically filed by the last two
digits, then the middle two digits, and finally the first
two digits.

In that case I'd suggest storing the last two digits, the middle two
digits, and the first two digits in three fields in your table,
concatenating them when needed for display purposes!