Just use <
For example, in G1 put Completion Date and in G2 put <TBD
Then in your DCOUNT formula, the criteria is simply G1:G2
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"chadwick" wrote:

Hi all - a simple question (I think).

I'm trying to use the DCount function to count all records for which
the "Completion Date" field is NOT "TBD." I can easily count all
records whose dates are "TBD," or any specific date, eg "9/15/2002," by
simply entering that info in the criteria field that I'm referencing.
Can anyone tell me how to enter a NOT criterion?

As always, all help is greatly appreciated. Thanks.