access vba 求医, 这段有何问题(zzz)

ZZBZZBZZZB

mysqln = "select sum(借方金额) as a1,sum(贷方金额) as a2
from 清单 " & "where month(日期)=" & Month(Now())






mysqln = "select sum(借方金额) as a1,sum(贷方金额) as a2
from 清单 " & "where month(日期)=" & Month(Now()) And 凭证号 = A




第一段的没问题,第二段编译也没发现问题,可就是查询不出来什么东西,应是能查出的.向各位高手请教

Henry D. Sy

mysqln = "select sum(借方金额) as a1,sum(贷方金额) as a2
from 清单  where month(日期)=" & Month(Now()) & "  And 凭证号 ='A'"

ZZBZZBZZZB

mysqln = "select sum(借方金额) as a1,sum(贷方金额) as a2" from 清单  where month(日期)=" & Month(Now()) & " And 凭证号 ='A'"

提示 缺少语句结束呀

ZZBZZBZZZB

忘了说明,A是长整形变量

Henry D. Sy

mysqln = "select sum(借方金额) as a1,sum(贷方金额) as a2" from 清单  where month(日期)=" & Month(Now()) & " And 凭证号 =" & A

ZZBZZBZZZB

就是这个了,多谢!