Displaying a sum on a report

[shbond]

Please help me....

I have a field in a table called CostRed. I also have a date field linked to each record. The CostRed field is a numeric field and I would like to display the sum of all these fields within certain dates on a report. I have tried 2 potential solutions so far, firstly writing a query to generate the sum and putting it into a new table; and secondly using a formula as the control source on the text box on the report. Neither of these seem to work. Am I going about this the wrong way or I there something I am missing?

Any help would be gratefully received.
Thanks
Stuart

 

[simongallop]

If you want to sum by day then right click top left hand corner of report in design view and select sorting and grouping. Select the date field and choose group footer.

Place tthe date field and the numeric field in the design section, then place a textbox in the group footer and have it sum the required field.

This will now subdivide you report by date

If you want to sum over a period then I would suggest create a query that gives the required answer and create a sub report showing the data from the new query

HTH