Using the following in a group footing in text box in a report. I want the amount field [ConAmt] totaled if the Date field [ConDte] falls between the specified dates. Contributions is the name of the table. I get #error on report. What do I need to do. Please keep simple; still learning. Thanks.
=DSum("[ConAmt]","Contributions","[MemID]=2 and [ConDte] Between #01/01/2010# And #01/31/2010#")