我有这个可以正常工作的Select语句:
rsCurrent.Source = "SELECT Calibrations.Cust_Ref, Calibrations.Rec_Date, Instruments.Inst_ID, Instruments.Description, Instruments.Model_no, Instruments.Manufacturer, Instruments.Serial_no, Instruments.Status, Instruments.Cust_Acc_No FROM Instruments INNER JOIN Calibrations ON Instruments.Inst_ID = Calibrations.Inst_ID WHERE Instruments.Cust_Name = '" & Session("MM_Username") & "' AND Instruments.Cust_Acc_No = '" & Session("MM_Password") & "' AND Instruments.Cust_Acc_No = '" + Replace(rsCurrent__MMColParam, "'", "''") + "' AND Instruments.Status IN ('E','F','G','H','I','K','L','M','N');"
我尝试了不同的方法来尝试按降序设置记录以查找Calibrations.Rec_Date
我究竟做错了什么?
尝试,
rsCurrent.Source = "SELECT Calibrations.Cust_Ref, Calibrations.Rec_Date, Instruments.Inst_ID, Instruments.Description, Instruments.Model_no, Instruments.Manufacturer, Instruments.Serial_no, Instruments.Status, Instruments.Cust_Acc_No FROM Instruments INNER JOIN Calibrations ON Instruments.Inst_ID = Calibrations.Inst_ID WHERE Instruments.Cust_Name = '" & Session("MM_Username") & "' AND Instruments.Cust_Acc_No = '" & Session("MM_Password") & "' AND Instruments.Cust_Acc_No = '" + Replace(rsCurrent__MMColParam, "'", "''") + "' AND Instruments.Status IN ('E','F','G','H','I','K','L','M','N') ORDER BY Calibrations.Rec_Date DESC;"
http://www.w3schools.com/sql/sql_orderby.asp
您可能要尝试ORDER BY DATE(Calibrations.Rec_Date)
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句