[belajar-access] Select access (date)

[N17R4 H4F45]

para master msacc.........

saya pnya data :
table1 

tanggal1         tanggal2JML
(date)(date)(LongInteger)
========================================
01-02-201001-02-201110
nullnull3
01-05-201001-05-20113
========================================


Lalu masukan saya : 05-2010   (lcInputan)

LcSql = "" & _
" Select sum(jml) as jmltot Table1 " &_
" where isnull(tanggal1) OR " & _
                 "('" & DateAdd("d", 0, Format("1" & "/" & Left(lcInputan, 2) & 
"/" & Mid(lcInputan, 4, 4), "dd/mm/yyyy")) & "' BETWEEN bln1 AND plus11) " & _
                " )"

Msalah kenapa kok hasil : JmlTot = 13????

=================
trimakasih sebelumnya atas solusinya.