18-05-17, 04:00 AM
جرب هذا التعديل
كود :
adodc1.RecordSource = _
" SELECT COUNT(*) AS [zTotal] " & _
" FROM [Table1] " & _
" WHERE ( [NAME] = 'محمد' ) " & _
" AND ( [KIND] = 'زيتون' ) " & _
" AND ( [DATEOF] BETWEEN #01/01/2017# AND #30/03/2017# ) "