第1个回答 2019-12-17
select
count(duicuo)
from
sheet1
where
duicuo='0'//这才是统计出为0的个数然后再select
ID
from
sheet1
where
duicuo='0'//这是列出为0的全部数据ID
第2个回答 2009-09-11
若Combo1.Text为资料表时需加上[]
qy1.Open "SELECT * FROM [" & Combo1.Text & "] where 栏位命='" & combo2.text &"'", cnn, adOpenKeyset, adLockReadOnly本回答被提问者采纳
第3个回答 2009-09-11
难道combo1.text是表名?
qy1.Open "SELECT * FROM " & Combo1.Text & " where 字段名称='" & combo2.text &"'", cnn, adOpenKeyset, adLockReadOnly
第4个回答 2009-09-10
qy1.Open "SELECT * FROM " & Combo1.Text & "and ..." & Combo2.Text, cnn, adOpenKeyset, adLockReadOnly
第5个回答 2009-09-11
qy1.Open "SELECT * FROM " & Combo1.Text&" union SELECT * FROM "&Combo2.Text, cnn, adOpenKeyset, adLockReadOnly