help with report detail footers

[Guest]

In my report I have things organized in a Date detail. it basicly looks like
this:
2005
Febuary Prices Sales
Total Gross = prices*sales
January Prices Sales
Total Gross
I want in my footer to display the end of the year total gross. its not a
sum or any other function, i just to display the number easy to find. But all
i can get it to display is the first total gross in this case, january. I
want it to show the last entry, december. How do i tell it to do that.
Somehow, i managed to get the report footer to do it. I don't know what i
did though and i can't figure it out.

 

[Guest]

Well we can not figure how you did it without a whole lot more information.

You can by opening the report in design view and checking what you have in
the footer that displays the data you are getting.

It is known as reverse engineering - taking something apart to see how it
was built.

Continue backwards through the record source for the reportand then any
queries that are the record source.