Sorting Roman Number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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.
 
Back
Top