Office中国论坛/Access中国论坛

标题: 如何实现这样的转换? [打印本页]

作者: xcyd    时间: 2009-8-6 02:32
标题: 如何实现这样的转换?
原表:
ZKZHXMKMHZF
0882101001庄锦荣031116
0882101001庄锦荣005140
0882101001庄锦荣002121
0882101001庄锦荣011115
0882101001庄锦荣001100
0882101002张怡玲002113
0882101002张怡玲031120
0882101002张怡玲011109
0882101002张怡玲001116
0882101002张怡玲005134
转换后:
ZKZHXMKM001KM002KM005KM011KM031
0882101001庄锦荣100121140115116
0882101002张怡玲116113134109120





欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/) Powered by Discuz! X3.3