trying to sum a total between 2 dates...

[mahaMutant]

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 & "#&quot

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 [

 

[scriverb]

Is there a field/column in the query called Total? This seems to be what you are trying to Sum with your DSum statement. I can see nothing wrong with the DSum Statement but I would like to see the SQL for the query qry_SalesSum.

I noticed in your post that you refer to qry_SalesSummary at the top and then in the Function your refer to qry_SalesSum. Are there two different queries here?

Can you post that code? It would help.

Bob Scriver

 

[RichUK]

Since the subform already has the records concerned you only need to Sum the relevant sales in the subform footer. ie.=Sum([Sales])