G
Guest
Hi all
I got stuck in the following situation.
I have a query which have several columns.
In the query's design view, I have set sort order for several (about six)
columns according to their priority, which is a little bit complicated.
So in the datasheet view, the data are sort in the desired order.
Then I creat a form base on this query,
and in the datasheet view of this form
the data follows the sorting pattern of the query, which is fine.
But the problem comes that when I perform a A-Z or Z-A sorting on any one
column,
The original sort order is over-rided and cannot be reversed.
Even when I close the form and reopen it, the sorting order still follow the
last sorting order, i.e, the unwanted one.
I wish to know if there is a way to have the sort order be changed back to
the original setting.
Simon Wong
I got stuck in the following situation.
I have a query which have several columns.
In the query's design view, I have set sort order for several (about six)
columns according to their priority, which is a little bit complicated.
So in the datasheet view, the data are sort in the desired order.
Then I creat a form base on this query,
and in the datasheet view of this form
the data follows the sorting pattern of the query, which is fine.
But the problem comes that when I perform a A-Z or Z-A sorting on any one
column,
The original sort order is over-rided and cannot be reversed.
Even when I close the form and reopen it, the sorting order still follow the
last sorting order, i.e, the unwanted one.
I wish to know if there is a way to have the sort order be changed back to
the original setting.
Simon Wong