Value sort

[The Headache]

Hi

I put this post originally in the layout forum and received no reply so I am trying this forum (which I just discovered -duh!) I also tried to search for an answer but, zip so far.

I have a field with a defined value list on two different layouts. One a drop down the other a pop up menu.

The values are from the field itself. The values are "batch numbers" so it builds the list 1,2,3 etc.

Currently the list sorts 1 through the highest number. I would like it to sort the opposite so the highest number is at the top.

Possible?

Thanks for your patience and any help.

P.S. I'm at work on 8.5 Advanced on XP in case my home profile shows up as 9 & Mac

[Raybaudi]

Hi

create the list using negative numbers.

Then use the Abs ( ) function.

InverseSortedValueList.zip