Sorting by columns

[alex_aqui]

I'm sorry if this has come up, but its been a while and I'm a bit rusty, so please forgive me.

Basically, I have a form with a subform containing a continuous dataset with 6 columns of data. I would like to give the user the ability to sort each of those columns by either ascending or descending by pressing a button (column header) for each row. Ie, one column is time, so I would like the user to sort the data by time, etc.. How do I adjust the sorting order and sort column of a subform's query?

Thanks in advance for any assistance.

 

[Dave Eyley]

Right Mouse Click on the column's data to be sorted and select the option.

This should work in both datasheet and continuous forms view.


HTH

Dave E

 

[razorking]

http://www.microsoft-accesssolutions.co.uk/sort_listbox_columns.htm