请教如何把记录中的非空字段内容复制到另一个表呢？

先做字段合并查询,然后借助自定义函数再做分列查询.

select id,姓名,iif(isnull([a]),"",[a] & ",") & iif(isnull([b]),"",[b] & ",")... ...& iif(isnull([f]),"",[f] & ",") as 联合 from 表1;   第一个查询,命名为"查询1"

select id,姓名,mysplit(联合,1) as 项目1,mysplit(联合,2) as 项目2,mysplit(联合,3) as 项目3 from 查询1;

function mysplit(str as string,c as long) as string

'str:要进行分列的字符串;c:要获得的分列后的第几列.

'用法举例:mysplit("a,b,c,d",3)  '返回 c,即用逗号把传入的字符串分列后,返回第三列的值

dim ar

ar=split(str,",")

myslip=ar(c-1)

end function