Hello, I have the following equati

[tennis]

Hello,
I have the following equation in the control source and it works:
=DSum("[Amt of Dues]","City","[Amt Paid]=0&quot

Also, the following works:
=DSum(&quot;[Amt of Dues]&quot;,&quot;City&quot;,&quot; [City]![Date Paid]<=&quot; & &quot;[Reports]![Combined Dues Ending]![Select_Date]&quot

However, when I try to use an AND statement I don't get any results. The equation I am using is:

=DSum(&quot;[Amt of Dues]&quot;,&quot;City&quot;,&quot;[Amt Paid]=0 And &quot; &
&quot;[City]![Date Paid] <= #&quot; &
[Reports]![Combined Dues Ending]![Select_Date] & &quot;#&quot

Thank you

 

[Darrylles]

Hi ten,

After pasting the above, I got double spaces within the text
(specifically directly after &quot;[Amt Paid]=0 And &quot.

Only thing I could see.

Reply if no diff....

Regards,

Darrylle



&quot;Never argue with an idiot, he'll bring you down to his level - then beat you with experience.&quot;

 

[JeremyNYC]

The double spaces won't make a difference. Are you positive that there are data that match both of those criteria?

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.