dim i as integer
dim nn as integer
for i=1 to 6
  for nn=78 to 83
     Adodc13.RecordSource ="""" & "select * from Downpart where [group] like 'S" & i & "%' and [Detail] like '" & label11(35).caption & "'" & """"
     adodc13.refresh
     label11(nn).caption=adodc13.recordset.recordcount
  next nn
next i

这句话怎么纠正,先说明一下i是变量
我用msgbox的结果为:
"select * from Downpart where [group] like 'S7%' and [Detail] like 'AE connector card'"
这个结果是我想要的,但是在
 Adodc13.RecordSource ="""" & "select * from Downpart where [group] like 'S" & i & "%' and [Detail] like '" & label11(35).caption & "'" & """"
为什么会不通过呢,请各位帮忙指正,谢谢!

各位,我还在不停的调试中,
如果有谁清楚,请帮忙将我的code进行修正,谢谢!

风老师所说的情况我知道,但是如果我不加双引号,这个是没有结果的.

说清楚点就是
"select * from Downpart where [group] like 'S7%' and [Detail] like 'AE connector card'"
7是变量
ae connector card是变量
这个语句该如何做?

用adodc绑定的access

dim i as ingeger
dim nn as ingeger
for i=1 to 6
    for nn=78 to 83
       adodc13.recordsource="select*from downpart where [group] like 'S" & i & "%' and [detail]like '" & label11(68).caption & "'"
       adodc13.refresh
       label11(nn).caption=adodc13.recordset.recordcount
    next nn
next i

怎么没有结果呢?

我确定最后一个条件是有的

根据条件筛选出来的要统计出记录的数量,所以才会用到Adodc13.recordset.recordcount

不细心呀
现在终于找到问题了.

dim i as ingeger
for i=1 to 6
    adodc13.recordsource="select*from downpart where [group] like 'S" & i & "%' and [detail]like '" & label11(68).caption & "'"
    adodc13.refresh
    label11(i+77).caption=adodc13.recordset.recordcount
next i