Drag & Drop Sort Order

[Jared]

I have a report that lists ~20 items in a subreport.
These items i have sorted presently by aphabetical order.

I would like to be able to allow the user to define a sort order like the
drag and drop method used when setting the tab order of controls on a form.

Is there a way set up a form similar to the tab order dialog that allows the
user to do this? Thankyou in advance.

 

[Douglas J. Steele]

No easy way that I can think of.

Typically what you need to do to allow a custom sort order is to add a
SortOrder field (or sometimes an additional table that has the name and the
sort order, and link that table to the other tables in the query).