Prev: DCount with one single condition works, but several ones, joinedtogether with the logical operator AND, do not!
Next: Photo Directory Template
From: Duane Hookom on 9 Feb 2010 13:41
You made it more complex than required:

=DCount("[ID]", "Table", "[ConditionYesNo1] = 0 AND [ConditionYesNo2] = 0" )

You could also try
=DCount("[ID]", "Table", "[ConditionYesNo1] + [ConditionYesNo2] = 0" )

--
Duane Hookom
Microsoft Access MVP


"Henrik Jansson" wrote:

> Dear friends out there,
>
> I simply do not understand this. What's wrong with the syntax in my
> Access-2007 report?
>
> =DCount("[ID]", "Table", "[ConditionYesNo1] = No") -----> returns a correct
> minor total of all records with no checkmarks in the field (column)
> "ConditionYesNo1".
>
> =DCount("[ID]", "Table", "[ConditionYesNo1] = No" AND "[ConditionYesNo2] =
> No" ) -----> returns ALL records. Why i that?
>
> Thanks in advance
>
> Henrik
>
>
> __________ Information från ESET NOD32 Antivirus, version av virussignaturdatabas 4848 (20100208) __________
>
> Meddelandet har kontrollerats av ESET NOD32 Antivirus.
>
> http://www.esetscandinavia.com
>
>
>
> .
>
 | 
Pages: 1
Prev: DCount with one single condition works, but several ones, joinedtogether with the logical operator AND, do not!
Next: Photo Directory Template