Report total

[jcdifi26]

Not sure if I can do this or not but here goes. I'm using Access 2003.
I have a report that has these two fields [Date] and [Cost]. In the
query I have parameters in the Date field to run the report Between
[Start_Date] and [End_Date]. I usually run the report for a specific
period with a Sum funcition in the report footer for Total Cost. I
want to put another field in the report footer that shows Year to Date
Costs. So, for example, if I run the Report from 8/1/04 to 8/31/04 I
will get the Total Cost for August, but in the YTD field it will
capture all the costs in the query from 1/1/04 to 12/31/04. Can I do
this?

Thanks, Joe

 

[Duane Hookom]

I would allow users to enter the dates into text boxes on a form. This
provides much more functionality. You could then use the dates in two
queries:
1) the main report's record source
2) a query for a subreport that would return the YTD value