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

Please stick to a single thread. It is a weekend after all and fewer people are inclined to lurk looking for questions to answerl

http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=130839#post130839