错哪里？sqlselect * from lrlxhb where year(bbnd)&dis_ndsqlselect * from lrlxhb where year(bbnd
错哪里？sql="select * from lrlxhb where year(bbnd)="&dis_nd
sql="select * from lrlxhb where year(bbnd)="&dis_nd
Microsoft][ODBC Microsoft Access Driver] 参数不足，期待是 1
[解决办法]
sql="select * from (select year(bbnd) as yy from lrlxhb) where yy=" & dis_nd+";"
[解决办法]
sql="select * from lrlxhb where bbnd like %"&dis_nd&"%"