環境：ACCESS2010鏈接sql server 2008使用。wdangandrd是一個鏈接表。
問題陳述句：
SELECT
wdangandrd.[index] AS A,
Wdangandrd.Wloanunit AS B,
Wdangandrd.Wname AS C,
Wdangandrd.Wloanvalue AS D,
Wdangandrd.Wstartdate AS E,
Wdangandrd.Wenddate AS F,
Wdangandrd.Wdanbaofs AS G,
Wdangandrd.Wmanager AS H,
Wdangandrd.Wboxindex AS I,
Wdangandrd.Wheshu AS J,
Wdangandrd.Wbenshu AS K,
Wdangandrd.Wyeshu AS L,
Wdangandrd.Wtjsj AS M,
Wdangandrd.Wtjr AS N,
"" AS O,
"" AS P
FROM Wdangandrd
WHERE
wdangandrd.[index]>liststartindex()
and wdangandrd.[index]<=(select max([index]) from wdangandrd)
and userid=SQLbianliang()
ORDER BY Wdangandrd.Wboxindex ASC
其中：
liststartindex()，SQLbianliang()是程式運行中賦予的函式。
問題：
呼叫這各查詢生成報表時，未能按照Wdangandrd.Wboxindex欄位進行排序。嘗試將where陳述句更改為簡單的比如userid="aaa"時，報表能實作排序。
請教：哪里出問題了，應該怎么改？謝謝！
uj5u.com熱心網友回復：
大神，出現吧！uj5u.com熱心網友回復：
SQLbianliang()的回傳型別是不是字串？liststartindex()的回傳型別是什么？用Like試試看，參看這篇：https://support.microsoft.com/zh-cn/office/access-sql%ef%bc%9awhere-子句-753bbc13-debc-4b28-b527-42eb7885c862?ui=zh-cn&rs=zh-cn&ad=cn
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/14997.html
標籤：Access
上一篇：python