odd & even Numbers

[bluey]

Is there an expression that can sort odd numbers from evens

 

[Tim K.]

The SQL below sorts even numbers first, then sorts the odd numbers. I assume the table names tblOddEvenNos with the Number field.

SELECT tblOddEvenNos.Number
FROM tblOddEvenNos
WHERE ((([number] Mod 2)<>0 Or ([number] Mod 2)=0))
ORDER BY [number] Mod 2, tblOddEvenNos.Number;

and the SQL sorts the odd numbers first.

SELECT tblOddEvenNos.Number
FROM tblOddEvenNos
WHERE ((([number] Mod 2)<>0 Or ([number] Mod 2)=0))
ORDER BY [number] Mod 2 DESC , tblOddEvenNos.Number;

 

[bluey]

thanks this is for a friend so i dont know mutch about it.