DCount Greater Than Criteria

[Garridon]

I've been trying to do a DCount which counts the records that are greater than 0, but I keep getting a #Error.

This is what I've been using:

=DCount(&quot;Days Elapsed&quot;,&quot;TestReport&quot;,&quot; [Days Elapsed]<#&quot; & &quot;0&quot

Can anyone help? This thing has been driving me crazy. Thanks!

Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com

 

[MichaelRed]

The first expression works for me in debug. with (of course) MY table/field Names.

? DCount(&quot;DaysInMnth&quot;,&quot;nWeeks&quot;,&quot; [DaysInMnth] > &quot; & &quot;29&quot

Thei (second) expr SHOULD work for you - assuming that your table / field names are correct. The only (intended) difference is the 'removal' of the &quot;#&quot;.



=DCount(&quot;Days Elapsed&quot;,&quot;TestReport&quot;,&quot; [Days Elapsed] <&quot; & &quot;0&quot


MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[Garridon]

Afraid not. I still get the same error (#error).

Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com

 

[JohnLowell]

Try this:

=DCount(&quot;[Days Elapsed]&quot;,&quot;[TestReport]&quot;,&quot;[Days Elapsed]> 0&quot

Let me know if this helps.