Redian新闻
>
Help needed: How to sort the dates in MS Access
avatar
Help needed: How to sort the dates in MS Access# Database - 数据库
s*u
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
avatar
j*w
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

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。