mahaMutant
Programmer
Form with 2 text boxes and a subform holding records returned from qry_SalesSummary.
I am trying to sum the totals with the following aggregate function, i think the sql string is not quite right:
Forms!frm_SalesSummary_Main!Total = DSum("[Total]", "qry_SalesSum", "[ProccessDate] Between #" & strFromDate & "# And #" & strToDate & "#"
If I enter from the form the date parameters as:
02/02/2002 and 02/03/2002 [in 2 text boxes] i get the records retunrned in a subform OK, but the Total is either empty or inaccurate or it returns the total of the WHOLE query [sum of all the sales].
Please help.. ] always a sucker to the greatest lie of all: will only take a minute [
I am trying to sum the totals with the following aggregate function, i think the sql string is not quite right:
Forms!frm_SalesSummary_Main!Total = DSum("[Total]", "qry_SalesSum", "[ProccessDate] Between #" & strFromDate & "# And #" & strToDate & "#"
If I enter from the form the date parameters as:
02/02/2002 and 02/03/2002 [in 2 text boxes] i get the records retunrned in a subform OK, but the Total is either empty or inaccurate or it returns the total of the WHOLE query [sum of all the sales].
Please help.. ] always a sucker to the greatest lie of all: will only take a minute [