Erin M 2021
Member
- Local time
- Today, 14:08
- Joined
- Apr 14, 2021
- Messages
- 77
Another inherited report that is not counting correctly.
Here is what was written: Me!FYTDNewDonor.Value = ECount("[Constit_id]", "[FY Gifts]", "[DTE] BETWEEN #" & dFYStart & "# AND #" & dReport & "# AND ([FirstGiftDate] >= #" & dFYStart & "# or [FirstGiftDate] is Null)")
I need the distinct count of [Constit_id].
Thanks in advance!
Here is what was written: Me!FYTDNewDonor.Value = ECount("[Constit_id]", "[FY Gifts]", "[DTE] BETWEEN #" & dFYStart & "# AND #" & dReport & "# AND ([FirstGiftDate] >= #" & dFYStart & "# or [FirstGiftDate] is Null)")
I need the distinct count of [Constit_id].
Thanks in advance!