ACCESS from 子句语法错误。

        public DataTable SelectDataStyleAllFinance(string FinanceStyle, string FinanceData)
        {
            strOleDb = new StringBuilder();
            strOleDb.Append("select Department as 来文机关或部门,Sort as 类别,Amount as 份数,FinanceData as 收到日期,OrderNum as 顺序号,FileNum as 来文号,ArchivesNum as 归入案卷号,FileTitle as 拟办 from Finance");
            strOleDb.Append("where FileStyle='" + FinanceStyle + "'and FinanceData='#" + FinanceData + "#'");
            strOleDb.Append("order by FinanceID desc");

            return DB.Fill(strOleDb.ToString());
        }

是WHERE 中错误么？如何改，急求

---

from Finace 后
或
where FileStyle前

加一个空格.

---

like FinanceData='#" ?

---

引用

from Finace 后
或
where FileStyle前

加一个空格.

加了 没用 跟空格没关系啊

---

引用

like FinanceData='#" ?

哪里错了？

---

up

---

strOleDb.Append("where FileStyle='" + FinanceStyle + "'a