Hi all,
I can't get this sorted.
I have created a report where I want to display the total number of records that were created today. So I have set the following control source for my textbox.
EditDate = Date/Time field
EditRecordID = PK
Why is this not working?
I can't get this sorted.
I have created a report where I want to display the total number of records that were created today. So I have set the following control source for my textbox.
Code:
=DCount("[EditRecordID]";"tblActionLog";"Format([EditDate];'mm\/dd\/yyyy') = Format(Date();'mm\/dd\/yyyy'")
Or
=DCount("[EditRecordID]"; "tblActionLog"; "[EditDate]=#" & Date() &"#")
EditDate = Date/Time field
EditRecordID = PK
Why is this not working?