Access 2007: How to clear sort on column in query data sheet view?

[Broons Bane]

When I run a query and manually sort one of the calculated columns in
the resulting datasheet, how do I then clear this sort? it doesn't
appear to be possible.

 

[Albert D. Kallal]

In the ribbon, you see

a-z
z-a
az with a "eraser" because it...

Simply choose the 3rd option. If you hold your cursor above, you see the
text


"clear all sorts"

 

[Broons Bane]

In the ribbon, you see

a-z
z-a
az with a "eraser" because it...

Simply choose the 3rd option. If you hold your cursor above, you see the
text

"clear all sorts"

Thank you! It was that damn ribbon again was it?