Is is possible to write a query that puts any 0's last, but keeps >0 in ascending numeric order ?
Is is possible to write a query that puts any 0's last, but keeps >0 in ascending numeric order ?
Calculate another field that assigns a value of 1 to the non-zero records and 2 to the zero records.
SELECT * FROM table ORDER BY IIf(field = 0, 2, 1), field;
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks June that did it nicely.