Hello,
I have the following equation in the control source and it works:
=DSum("[Amt of Dues]","City","[Amt Paid]=0")
However, I also need to add another criteria to the above equation regarding dates, I have the following equation:
=DSum("[Amt of Dues]","City","[Amt Paid]=0" And "[City]![Date Paid]<=" & "[Reports]![Combined Dues Ending]![Select_Date]")
The above equation simply adds the field [Amt of Dues]. It does not take into consideration that I only want to add the field when Amt Paid = 0 AND Date Paid <= Select Date.
How to I correct the above equation?
Thank you
I have the following equation in the control source and it works:
=DSum("[Amt of Dues]","City","[Amt Paid]=0")
However, I also need to add another criteria to the above equation regarding dates, I have the following equation:
=DSum("[Amt of Dues]","City","[Amt Paid]=0" And "[City]![Date Paid]<=" & "[Reports]![Combined Dues Ending]![Select_Date]")
The above equation simply adds the field [Amt of Dues]. It does not take into consideration that I only want to add the field when Amt Paid = 0 AND Date Paid <= Select Date.
How to I correct the above equation?
Thank you
