another date problem

p0welly

Registered User.
Local time
Today, 07:26
Joined
Aug 26, 2004
Messages
38
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?
 
str = "[CustomerID] = " & Reports!rptAccountMonthly!CustomerID & " And [ControlDate] > #" & [Forms]![frmAccountManagement]![StartDate] & "#"

soon as you post it clicks, id missed the #'s
 

Users who are viewing this thread

Back
Top Bottom