Sorting Roman Number

S

srikanth

How do i sort roman number in ascending or decending manner in access report.
Bcoz when I choose ascending in roman number immediately after IV... IX is
being displayed instead of V.. VI.. VII.. VIII and then IX
 
D

Douglas J. Steele

You'd have to have a table of Roman Numerals that also includes a "proper"
sort key, and join that table to your existing one(s), sorting on the new
sort key.
 
D

Douglas J. Steele

Roman SortOrder
I 1
II 2
III 3
IV 4
V 5

and so on.

You then join that table to the rest of your query on the Roman numerals,
and sort on SortOrder.

Another option would be to have function that converts from Roman numerals
to their numeric equivalent, add that function as a computed field in your
query and sort on it.

The table approach will be faster, but it requires that you have every
possible Roman numeral you might use in the table.
 
Top