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