str = "[CustomerID] = " & Reports!rptAccountMonthly!CustomerID & " And [ControlDate] > " & [Forms]![frmAccountManagement]![StartDate] & ""
varMonth1Charges = DSum("Amount", "[tblAccount]", str)
the above appears to be giving me the sum of all of the customers amounts rather than just those after where the controldate is after the reports startdate
any ideas?
varMonth1Charges = DSum("Amount", "[tblAccount]", str)
the above appears to be giving me the sum of all of the customers amounts rather than just those after where the controldate is after the reports startdate
any ideas?