Calculated field in a form

[Pettor]

Hi all,

I have a question about forms.
I have created one in order to import details in a table but I would like to have a separate field that will count the number of records for a given date.
So when I enter the new record and place the details + the date, I want it to present the number of the records that are already registered in the table with the same date.

Can anyone please help? Thanks!

 

[Pettor]

Case solved.

=DCount("[MDATE]";"tblName";"[MDATE]=#" & Format([XDATE];"mm/dd/yyyy") & "#")