order by case for a query

[akapag22]

Hi friends



In a table the data is available in the follwing way:

CustomerID Stage DOE

3 stageA 06/23/2015
1 SatgeC 06/24/2015
2 NoStage 06/25/2015


So Ignoring Nostages, the most recent doe is for customer id :1
then customer iD 3 and then CustomerID: 2 (Nostages) at the end of the result

So i want to order by results in the above fashion 1,3,2 . is this possible in access using case.

[ranman256]

You only have 3 ways to sort.
customer, stage , or DOE.

i don't see what you're doing.

[akapag22]

Hi ranman i want to sort by DOE but only for those records that don't have NoStage and then append the Nostage records later.

[lfpm062010]

This is one option.

Create 2 queries, 1 query does not include "NoStage" and sort DOE in descending and the 2nd query only inlcue "NoStage" and sort DOE in descending.

Create the 3rd query to "UNION" the 2 queries above.

[ranman256]

yes, union query.
(your example threw me, you said 1,3,2, but you really meant 3,1,2)