关于排序(不按英文字母顺序排)的问题?

lhybird

能不能实现按以下顺序排序:

M1,M2,M3,E1,E2,E3,G1,G2,G3,A1,A2,A3

谢谢!

lhybird

andymark 的sql

SELECT *
FROM Sheet1
WHERE MZ In ("M1","M2","M3","E1","E2","E3","G1","G2","G3","A1","A2","A3")
ORDER BY InStr(",M1,M2,M3,E1,E2,E3,G1,G2,G3,A1,A2,A3,","," & MZ & ",");

怎么才能在VB里使用?双引号和in,instr函数怎么办?

lhybird

谢谢大家的帮助

myszh

DESC 降序 的意思[em04]

lhybird

谢谢andymark提供的方法.

myszh,你好!你的

SELECT Sheet1.MZ
FROM Sheet1
GROUP BY Sheet1.MZ
ORDER BY Left([MZ],1) DESC , Right([MZ],1);
里的DESC是什么意思?

andymark

一点通

要有规律才行,如果按字母为降序,数字为升序,要将字段拆分,然后分别排序

myszh

你看看对不？


[em04]