Greeting,

I have table and it has field for date and it has too many duplicated date.
I have unbound form and it has unbound textbox.
What I want to do is input a date in the textbox and click on command button
after that access will matching the input date with the records and if there
are duplicated date will give the total number of them.
I use the following code but does not work

Dim dd As String
dd = Nz(DCount("[ndate]", "[dd]", "[ndate]=" & (Me.aa)), 0)
MsgBox dd

Any help please??