DCount with one single condition works, but several ones, joined together with the logical operator

[Henrik Jansson]

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

 

[John Spencer]

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

 

[Duane Hookom]

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

 

[Henrik Jansson]

Thank you so much John! That solved my problem.

Best regards,

Henrik

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

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

__________ Information från ESET NOD32 Antivirus, version av
virussignaturdatabas 4848 (20100208) __________

Meddelandet har kontrollerats av ESET NOD32 Antivirus.

http://www.esetscandinavia.com

__________ Information från ESET NOD32 Antivirus, version av virussignaturdatabas 4848 (20100208) __________

Meddelandet har kontrollerats av ESET NOD32 Antivirus.

http://www.esetscandinavia.com