[求助]要对表的连接近的数值合并,ACCESS能作吗?

blackwarter

ShanDong_CNCGROUP








qh


qs


gj


ss


fw


ym








202.102.144.128


202.102.144.143


CN


ShanDong


MAINT-CNCGROUP-SD


202.102.144.128/28





202.102.144.144


202.102.144.151


CN


ShanDong


MAINT-CNCGROUP-SD


202.102.144.144/29





202.102.144.152


202.102.144.159


CN


ShanDong


MAINT-CNCGROUP-SD


202.102.144.152/29





202.102.144.160


202.102.144.167


CN


ShanDong


MAINT-CNCGROUP-SD


202.102.144.160/29





例如这条,这些IP都是连续的第二条的qh接第一条的qs,


结果想合并成,就是一头一尾














202.102.144.128


202.102.144.167


CN


ShanDong


<FONT style="FONT-SIZE: 14pt" face=

blackwarter

不能直接贴啊!我换个方法写

blackwarter

例如

202.102.182.16|202.102.182.23|CN|ShanDong|MAINT-CNCGROUP-SD|202.102.182.16/29
202.102.182.24|202.102.182.31|CN|ShanDong|MAINT-CNCGROUP-SD|202.102.182.24/29
202.102.182.32|202.102.182.39|CN|ShanDong|MAINT-CNCGROUP-SD|202.102.182.32/29
202.102.182.40|202.102.182.47|CN|ShanDong|MAINT-CNCGROUP-SD|202.102.182.40/29

合并成,就是前两段都是头尾相连的,如

202.102.182.16|202.102.182.47|CN|ShanDong|MAINT-CNCGROUP-SD|这里要作计算比较麻烦,我谢了VB的方法

access 的模块里能用VB的方法吗?有没有例子可以参考啊?

多谢各位大大了

Joe5525601

select first(tbl.qh) as qh, last(tbl.qs) as qs, tbl.gj, tbl.ss, tbl.fw
from tbl
group by tbl.gj, tbl.ss, tbl.fw;

blackwarter

以下是引用Joe5525601在2006-11-30 10:52:00的发言：


select first(tbl.qh) as qh, last(tbl.qs) as qs, tbl.gj, tbl.ss, tbl.fw
from tbl
group by tbl.gj, tbl.ss, tbl.fw;

很感谢

问题是表内有上千条,我要逐条合并,还要判断能不能合并

最后结果也就有几百,几十条吧