表a 中有一列这样的数据F000001
F000002
F000003
F000004
F000005
....
F000012 怎样在access 里用SQL 查询得到这样的结果:F000001-F000004
F000005-F000008
F000009-F000012
F000002
F000003
F000004
F000005
....
F000012 怎样在access 里用SQL 查询得到这样的结果:F000001-F000004
F000005-F000008
F000009-F000012
from 表a
where mid(数据,2) mod 4=1
乱发贴,自己试了没有?
GROUP BY int((Clng(RIGHT(ID, 6))-0.1)/4)
SELECT MIN(ID)+'-'+MAX(ID) FROM A_TABLE
GROUP BY int((Clng(RIGHT(ID, 6))-0.1)/4)