Running Total

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Hi Everyone,

I am trying to find a way to show running total for 2008. I currently have a
running total query using entries for 2007. What I want to do now is to show
a running total for amounts being entered into the database starting 1-1-2008
with out changing the database. For my level of expertise, this seem
impossible but I have been surprised by the knowledge and skill of people in
this group that I am will to risk asking the impossible.

Any ideas?

Thanks.
 
Joe,
Not much info to go on, but...

All your records for 2007 and 2008 should all be in the same table.
Create a Totals query grouped by a bound field in your query.
Ex. YearGroup : Year(YourDateFieldName)

On the report, group and sort (Grouping & Sorting) on that YearGroup
field, with the totals for each year in the YearGroup Footer.
Your report should show the 2007 totals, then the 2008 totals, then the
2009, etc.. etc...
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Thanks you, Al. Sorry about the skimpy info but your response appears to be
the answer that I am looking for. I 'll post again if I don't get the results
I expect.

Have a good day!

Joe
 
Back
Top