Hello,
I have a simple make table query that occasionally mis sorts on a number column.
SELECT Usage, Sell, [Service Unit Number], TechID, Current], INTO Rank
FROM tblCombined_Final
ORDER BY Usage DESC , Sell;
The data type is double and I have the sort as descending...