Hi,
I have been trying to put a DCount function into a textbox so it will count how many meetings have happened this year, so far I can have it count the total amount of meetings but when I add in the criteria it comes up with #Error.
The syntax I am using is
Can anyone advise me on where I am going wrong?
Thank you
I have been trying to put a DCount function into a textbox so it will count how many meetings have happened this year, so far I can have it count the total amount of meetings but when I add in the criteria it comes up with #Error.
The syntax I am using is
=DCount("ID","Meetings in 2021","Date of Meeting = #*2021#")
Can anyone advise me on where I am going wrong?
Thank you