Excluding an item from a sort

[LanceA]

I am running a sort query, and would like to exclude one of the items from my list. Is there any way to do this in the criteria field?

Lance

 

[rac2]

Of course. Specify that the column does not have a value that is specific to the item you wish to exclude.

<> &quot;ducks&quot;

This will eliminate all ducks.

However, this may not be exactly what you mean. It might be that you want ducks in the list, just not sorted. This is the same as saying that you want to sort on two columns. So you need a column that identifies the ducks and has a value that will place the ducks first (or last). Everything that is not a duck will have a value that places them last (or first). Then sort on the ducky column and the other column that gives the general order. All ducks will be sorted to the top (or bottom) and all non-ducks will be sorted by the other column.