>Good day to you all,
>
>We have a table where the user can set a color to each record and the numeric value of the color is then saved in a field.
>
>We have been trying to sort the table on these colors, but we find it difficult to make them appear in some 'logical' order, for example light colors down to dark colors or different blue grouped together.
>
>We have ordered the records on the numberic value, on the red portion of them (using RGB()), the difference between the higest and the lowest RGB value etc., but we have found no satisfying solution.
>
>If anyone has a suggestion, I am all ears...
How about 3 numeric fields that are populated by using RGB() on a color's numeric value, then ordering by 1, 2, 3
descending. You'll get a lightest (white) first and gradually end up with black.
Danijel