dcount won't work?

  • Thread starter Thread starter Arlend Floyd
  • Start date Start date
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
 
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)
 
Back
Top