JithuAccess
Member
- Local time
- Yesterday, 20:44
- Joined
- Mar 3, 2020
- Messages
- 297
Hello Guys,
I want to find Total Decision made in a week in my Report and this is my Code:
Here in the criteria of Date I want to find the data between 1 week prior to the current week and this would be dates between 26-Apr-2021 and 30-Apr-2021.
I am getting the following Error:
Could you please let me know what would be the correct Syntax?
Thanks
I want to find Total Decision made in a week in my Report and this is my Code:
Code:
=DCount("strProgram","tblMaster Table]","strProgram='ABC-123' And datDecision Between DateAdd("d",-6-Weekday(Date(),2),Date()) And DateAdd("d",-2-Weekday(Date(),2),Date())"))
Here in the criteria of Date I want to find the data between 1 week prior to the current week and this would be dates between 26-Apr-2021 and 30-Apr-2021.
I am getting the following Error:
Could you please let me know what would be the correct Syntax?
Thanks