用字母排序 [英] Sorting with letters
本文介绍了用字母排序的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个数据库,我用字母表标记条目(A-Z)。但是,当我有更多的条目而不是字母有字母我然后加倍字母(AA-ZZ)等等。
我想创建一个排序代码,将列出所有单个字母然后是双字母,三重等等。
我有点像新手所以如果有人有一些想法我肯定会喜欢它以及一些细节。
非常感谢!
Adam
解决方案
你好,Adam。
尝试类似下面的内容:
展开 | 选择 | Wrap | / span> 行号
对不起,我在MS Access工作,并不熟悉VB编码。您能否提供一些有关如何完成建议的详细信息?
谢谢!
使用SQL视图访问Access中的查询
访问查询的基本SQL语法
http://en.wikipedia.org/wiki/Select_(SQL)
使用SQL表达式的ORDER BY子句编写的内容是什么:
展开 | 选择 | Wrap | 行号< /跨度>
I have a database where I label entries by the alphabet (A-Z). However, when I have more entries than the alphabet has letters I then double the letters (AA-ZZ) and so on.
I want to create a sorting code that will list all single letters then double letters, triple and so on.
I am somewhat of a novice so if anyone has some ideas I sure would appreciate it along with a bit of detail.
Thanks much!
Adam解决方案Hello, Adam.
Try something like the following:
Expand|Select|Wrap|Line Numbers
Sorry, I am working in MS Access and am not that familiar with VB Coding. Could you provide a bit more detail on how to complete your suggestion?
Thanks!
Queries in Access using SQL View
Basic SQL Syntax for Access Queries
http://en.wikipedia.org/wiki/Select_(SQL)
What makes records to be ordered is what is written in ORDER BY clause of SQL expression:
Expand|Select|Wrap|Line Numbers
这篇关于用字母排序的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文登录 关闭
扫码关注1秒登录发送“验证码”获取 | 15天全站免登陆