这样写
Dim str As String = ""For Each c As Col In Tables("表A").Cols If c.IsNumeric Then str &= "isnull(" & c.Name & ",0)+" End IfNextmsgbox(str.Trim("+"))