Hi guys..
I have a problem in Dcount function.. when i enter a date it didn't count correctly.. it take all the records of all the years.. and i want only the records that mentioned.. before that it was work correctly..
What is the wrong in this code
Dcount ("[Bill_no_BDM]","BillDataMov","[Isu_Kind_BDM]='not taken' And [zone_BDM]='" & [zone_BDM] & "'")
I have a problem in Dcount function.. when i enter a date it didn't count correctly.. it take all the records of all the years.. and i want only the records that mentioned.. before that it was work correctly..
What is the wrong in this code
Dcount ("[Bill_no_BDM]","BillDataMov","[Isu_Kind_BDM]='not taken' And [zone_BDM]='" & [zone_BDM] & "'")