Complex Sorts in Datasheet View

[Paul H]

I am presenting the option to users, since they are used to working in Excel, to view the data as a datasheet. It looks great, but they would like to be able to sort in different columns like they do in Excel. Outside of giving them a query to play with and maybe screw up, is there a way to provide this to them. I thought about building an Order By string for the form, but it got a little complicated when I considered the sort order and various ascendding and descending options.



I don't want to beat myself up over this if I don't have to (i.e. quick and dirty if possible).

Thanks in advance.

[June7]

Datasheet view has shortcut menu for sort and filter. Click the little triangle next to field name.

[Paul H]

June,

It doesn't seem to take multi column sorts. If I sort on a second column it preempts the first sort. I want to be able to provide multi-level sorts.
See next comment for more detail.

[Paul H]

I think I see how the heirarchy works, the last sort applied takes precedence. If I click on Store, then Date, the primary sort is on Date, secondary is on Store. If I click on Date then Store it is reversed.

Is this correct?


Is there a way to remove all sorts then start again?
I found the answer to this question by putting a button to run this code.

Me.subfrmResearch_TableView.Form.OrderByOn = False

I think I'm in the clear unless you have anything else.

[June7]

I'll take your word on that. I've never thought much about how that quick sort works.