Access Dcount function in access

S

simsima

Joined
Jan 22, 2016
Messages
3
Reaction score
0
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] & "'")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Access MS Access DCount function problem 0
DCount alwaysreturning 1 0
Access Macro Repeat Expression using value of a field in table 0
Dcount returning no results!!! 0
dcount 1
Dcount operation 2
DCount Not Working Properly 7

Top