Running Total

[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.

 

[Al Campagna]

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."

 

[Joe]

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

 

[Al Campagna]

OK Joe,
If you still have problems, post back on this thread. I'll monitor this
thread for at least 2 weeks.
--
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."