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

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

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

Thank you so much John! That solved my problem.

Best regards,

Henrik

"John Spencer" <(E-Mail Removed)> skrev i meddelandet
news:(E-Mail Removed)...
> 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
>>
>>
>>
>
> __________ 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