Sorting of Conditions ?

Peter · Mar 31, 2005

There is a condition code with description for a building.

Conditions like:
Roof
Paintwork
Floor
Structural
Other remarks
....

End user wants to sort the condition in alphabetical order
BUT he wants "Other remarks" as the last item. Is there
any trick ?

Thank you for your help.

Brendan Reynolds · Mar 31, 2005

SELECT tblTest.Condition
FROM tblTest
ORDER BY tblTest.Condition <> "Other remarks", tblTest.Condition;

Madhivanan · Mar 31, 2005

Select * from yourTable where <conditions and Field<>"otherColumns>
order by Filed asc
union all
Select * from yourTable where Filed="Other Columns"

Madhivanan

Peter · Apr 1, 2005

Dear Brendan,

Thank you for your advice.

Peter

-----Original Message-----
SELECT tblTest.Condition
FROM tblTest
ORDER BY tblTest.Condition <> "Other remarks", tblTest.Condition;

--
Brendan Reynolds (MVP)

.