Thank you Rick

I was assuming that Me.aa is a control on your form that contains a date
value. Is that correct?

Yes, it is unbound text box


Do the dates in your table include times as well? If so then you will only
find records that match what you enter into the form exactly to the second.
Note that formatting does not affect this. Only what is actually stored.

No, it does not

Do you get a response with no WHERE clause?
MsgBox DCount("*", "[dd]")

No, I do not

Do you get a proper response with a hard-coded WHERE clause value?
MsgBox DCount("*", "[dd]", "[ndate] = #2008-08-31#")

No, I do not

please advice??

"Rick Brandt" wrote:

Jon wrote:
Thank you Rick, but does not wok as well

I was assuming that Me.aa is a control on your form that contains a date
value. Is that correct?

Do the dates in your table include times as well? If so then you will only
find records that match what you enter into the form exactly to the second.
Note that formatting does not affect this. Only what is actually stored.

Do you get a response with no WHERE clause?
MsgBox DCount("*", "[dd]")

Do you get a proper response with a hard-coded WHERE clause value?
MsgBox DCount("*", "[dd]", "[ndate] = #2008-08-31#")




--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com