EM2021
New member
- Local time
- Today, 09:39
- Joined
- Aug 25, 2021
- Messages
- 24
Why does the follow sum calculation work but not count within the Q1 parameters? The Count gives me total in my query and ignores the Q1 parameter.
=Sum(IIf([Dateasked] Between [Forms]![Prospect Reports Manager]![Q2Start] And [Forms]![Prospect Reports Manager]![Q2End],[Amountasked],0))
=Count(IIf([Dateasked] Between [Forms]![Prospect Reports Manager]![Q2Start] And [Forms]![Prospect Reports Manager]![Q2End],[Amountasked],0))
=Sum(IIf([Dateasked] Between [Forms]![Prospect Reports Manager]![Q2Start] And [Forms]![Prospect Reports Manager]![Q2End],[Amountasked],0))
=Count(IIf([Dateasked] Between [Forms]![Prospect Reports Manager]![Q2Start] And [Forms]![Prospect Reports Manager]![Q2End],[Amountasked],0))