Access 编程急问!!小问题一个# Programming - 葵花宝典
l*u
1 楼
mstrSQL = "SELECT * FROM Household Where " _
& "Group like '*" & DoubleQuote(Me![cboSelect]) & "*'" _
& "AND Interest like '*" & DoubleQuote(Me![ComboSelect2]
) & "*'"
table: Household
想实现从table household 选出所有records, household.group 等于 组合框 cboselec
的等于零值,household.interest 等于组合框架comboSelect2的值.上面
上面那个执行不通,对VB的语法不熟,大家给看看哪写错了.
& "Group like '*" & DoubleQuote(Me![cboSelect]) & "*'" _
& "AND Interest like '*" & DoubleQuote(Me![ComboSelect2]
) & "*'"
table: Household
想实现从table household 选出所有records, household.group 等于 组合框 cboselec
的等于零值,household.interest 等于组合框架comboSelect2的值.上面
上面那个执行不通,对VB的语法不熟,大家给看看哪写错了.