Rs1. Open the "select * from zb Where is & lt;> '" & amp; "" & amp; "' order by positive + 0 desc, negative asc, code asc", conn, 1, 1
From a data table in the query field is is not null data sets with MSHFlexGrid1 shown in the following table.
The sorting principle: a. is data from more to less; B. negative data from less to more, C. number of digital part of growing up. That is, from 01,02,03,04... 48,49,50...

Ordered by now to the east, west, east back west] [requirements and other sorting principles as above, still achieve the following results can,

CodePudding user response:

 
Select * from zb Where is & lt;> 'the order by the left (number 1) asc, CLNG desc (positive), right (negative,' 00 '+ 2) asc 

Behind the simple adjustment of the order by sorting conditions, first row in front of the line, not testing you try

CodePudding user response:

Quote: reference, on the third floor of the 1st floor response:

[code=SQL]
Right (negative, '00' + 2) : ichiro great god, thank you very much! A success, but the data digits are uncertain, how should change?