DCOUNT function help

[sjcoll2]

I am currently working with the DCOUNT function. Here is the syntax that I am using:
Dcount(&quot;[MAIN TABLE]![SALES ORDER ID]&quot;, &quot;MAIN TABLE&quot;,&quot;[MAIN TABLE]!STATUS='CNL' AND [MAIN TABLE]![CREDIT HOLD]<>'YES'&quot

If I take the second criteria out ([credit hold]<>'yes', the function works properly. However, if the second criteria is in the function a #error is returned.

Any suggestions?

 

[tlbroadbent]

Is [Credit Hold] a Yes/No field. If it is, change the criteria to read. Make sure you leave off the quotes.

[MAIN TABLE]![CREDIT HOLD]<>True Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.