How do I put a record at end of list?

M

MFH

If I have a query with three columns A,B & C. How can I sort so that column A
is ascending, C is descending and for every record in B that has the text "x"
in it will be displayed at bottom of the list for each A record. For example,
it should look like this...


A1 Ba C3
A1 Bd C2
A1 Bf C1
A1 Bx C7

A2 Bh C3
A2 Bz C2
A2 Br C1
A2 Bx C5

Therefore, the first column is first sorted ascending. The last columns is
next sorted descending. And the record Bx is always put at the end for each
record A.
 
A

Allen Browne

Create a query into this table.

In the Sorting row beneath the first column, choose:
Ascending
and beneath the 3rd column, choose:
Descending

Then in a fresh column, in the Field row, enter:
([Field2] Like "*x")
and choose Descending in the sort column.
You can uncheck the Show box under this column.

I'm not clear from your description whether this 3rd column should be placed
between the other 2 to get the sorting you want.
 
Top