Search results

That's what i don't understand. The format in the original table is number(double) and is the same in the created table. Yet it the created table still is mis sorted randomly. Sometimes on the very first query run, or other times I can make multiple runs without error.

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...