JithuAccess
Member
- Local time
- Today, 10:45
- Joined
- Mar 3, 2020
- Messages
- 297
Hello Guys,
I want to get the total count based on two criterias. The first criteria is Country and the Second criteria is Date Received. The date received should be 7 Days prior to Today's Date. Today's date is 02-Mar-2021 and I want to find the total count between the dates between 23-Feb-2021 and 02-Mar-2021. I have put this Function in the Control Source Property of a Text Box
=count(iif([strCountry="USA" And [datReceived Date]=between Date() And Date()-7,1))
I am getting an Error. I think the syntax is wrong. Could you please help me to fix this?
Thanks
I want to get the total count based on two criterias. The first criteria is Country and the Second criteria is Date Received. The date received should be 7 Days prior to Today's Date. Today's date is 02-Mar-2021 and I want to find the total count between the dates between 23-Feb-2021 and 02-Mar-2021. I have put this Function in the Control Source Property of a Text Box
=count(iif([strCountry="USA" And [datReceived Date]=between Date() And Date()-7,1))
I am getting an Error. I think the syntax is wrong. Could you please help me to fix this?
Thanks