由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - Help needed: How to sort the dates in MS Access
相关主题
Oracle 有这种 create partially sorted index方法吗?SQL fast search in a 10 million records table (转载)
SORTING 中文 IN ORACLEUndefined function 'Date' in Expression
sortHelp for VB 6 and MS Access DB
[转载] How to sort chinese data?a question
新手求救:如何给我sort完的表填加一列自然数显示order?谁知道哪里找有关data warehouse的论文?
求教:怎么在select 出的结果里加一行请教怎么关闭MYSQL的debug信息
有没有讨论MongoDB的?ask for help
help with SAS sql (转载)How to prepare 70-433 exam?
相关话题的讨论汇总
话题: 06话题: 07话题: access话题: ms话题: dates
进入Database版参与讨论
1 (共1页)
s****u
发帖数: 23
1
I can't get the right order by simply sorting. It gave me the order like
1/1/06
....
1/31/06
1/1/07
...
1/31/07
2/1/06
....
2/28/06
2/1/07
...
2/28/07
instead of
1/1/06
....
1/31/06
2/1/06
....
2/28/06
1/1/07
...
1/31/07
2/1/07
...
2/28/07
Please advise, Thanks
j******w
发帖数: 4429
2
make sure they are date/time type
if it is text type, the reslut is your first one

【在 s****u 的大作中提到】
: I can't get the right order by simply sorting. It gave me the order like
: 1/1/06
: ....
: 1/31/06
: 1/1/07
: ...
: 1/31/07
: 2/1/06
: ....
: 2/28/06

1 (共1页)
进入Database版参与讨论
相关主题
How to prepare 70-433 exam?新手求救:如何给我sort完的表填加一列自然数显示order?
Help on JDBC:ODBC SOS求教:怎么在select 出的结果里加一行
Any Chinese Tutorial for Access Programming?有没有讨论MongoDB的?
[转载] what's the equivalent of 'minus' (oracle) in access?help with SAS sql (转载)
Oracle 有这种 create partially sorted index方法吗?SQL fast search in a 10 million records table (转载)
SORTING 中文 IN ORACLEUndefined function 'Date' in Expression
sortHelp for VB 6 and MS Access DB
[转载] How to sort chinese data?a question
相关话题的讨论汇总
话题: 06话题: 07话题: access话题: ms话题: dates