怎样能让access库中数字(整型)型数据类型中的数据按数字的大小降序排列?

[ready]

[wainman]

SQL语法为
select * from 你的表名 where 查询条件 order by 字段 desc
其中，desc表示降序。

[tripofdream]

sql="select * from table1 order by intcol desc"

[ready]

该语句提示错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)

[tripofdream]

这一句也会出错？^&%$$~
PRB: Error '80040e10' Too Few Parameters. Expected 1: Error Using ADO from ASP Against Access Database
ID: Q216425



--------------------------------------------------------------------------------
The information in this article applies to:

Microsoft Visual InterDev, version 6.0
ActiveX Data Objects (ADO), versions 2.0, 2.1 SP2

--------------------------------------------------------------------------------


SYMPTOMS
If you use ActiveX Data Objects (ADO) to manipulate data in an Access database from within an Active Server Pages (ASP), and you refer to a column in a table that does not exist, you may see the following error:



Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected 1.

Customer/ASP Page8.asp, line 12



CAUSE
This error occurs only with Microsoft Access when one of the column names specified in a select statement does not exist in the table being queried.

你不是把我那一句原封不动地抄上去的吧？
sql="select * from 你的表名 order by 要排序的整型字段 desc"