Prev: Formular call to access report
Next: Access 2007 Attachments
From: Marshall Barton on 18 Feb 2010 17:52
Arlend Floyd wrote:

>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)


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)

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: Formular call to access report
Next: Access 2007 Attachments