dcount won't work?

A

Arlend Floyd

This is what i have. I need to match all 3 criteria's. It returns all records
what am I doing wrong?

=nz(DCount("[TicklerID]","[dbo_Ticklers]","[RepForName] =
[Forms]![FrmToday]![FrmMenuSub]![FullName]" And "[TicklerRead] = 'New'" And
"[TicklerDone]=0"),0)

Thanks,

Arlend Floyd
 
M

Marshall Barton

Arlend said:
This is what i have. I need to match all 3 criteria's. It returns all records
what am I doing wrong?

=nz(DCount("[TicklerID]","[dbo_Ticklers]","[RepForName] =
[Forms]![FrmToday]![FrmMenuSub]![FullName]" And "[TicklerRead] = 'New'" And
"[TicklerDone]=0"),0)
Click to expand...


The ANDs need to be inside the quotes:

=Nz(DCount("[TicklerID]","[dbo_Ticklers]",
"RepForName = Forms!FrmToday!FrmMenuSub!FullName And
TicklerRead = 'New' And TicklerDone=0"), 0)
 

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 function in access 0
DCount alwaysreturning 1 0
Dcount return incorrect result for filtered record 4
Still struggling with DCount 8
Complex DCount in a Student "Summary" Form 1
Dcount help 1
DCount Question 3
DCount works for one field but does not work with two fields 12

Top