Prev: DCount with one single condition works, but several ones, joined together with the logical operator AND, do not!
Next: DCount with one single condition works, but several ones, joined t
From: John Spencer on 9 Feb 2010 13:05
Try the following correctly formatted argument.

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


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

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, joined together with the logical operator AND, do not!
Next: DCount with one single condition works, but several ones, joined t