Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running Totals Problem 1

Status
Not open for further replies.
DanKay1

DanKay1

Programmer
Jun 9, 2004
54
US
I have a table with Names and Amounts, I need to total those amounts based on the names before moving to next name. Have a running total per name. I tried doing it but all i get is the sum for all the names. Can you give me a tip please.
Thanks
 
Sort by date Sort by votes
Looking into Sorting and Grouping. You must group by the Name and then create a control in the Group Footer performing a Sum function on the Amount control.

If you need more assistance please post back.

[COLOR=006633]Bob Scriver[/color]
MIState1.gif
[COLOR=white 006633]MSU Spartan[/color]
 
Upvote 0 Downvote
scriverb ,
thanks for fast responce,
question about Group Footer, how can i insert into the report?
 
Upvote 0 Downvote
Glad that you figured it out. Thanks for the Star.

[COLOR=006633]Bob Scriver[/color]
MIState1.gif
[COLOR=white 006633]MSU Spartan[/color]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

soloracer
  • Locked
  • Question
Problem using report recordsource values within report events. Error 2427 1
Replies
17
Views
1K
soloracer
soloracer
Mike R
  • Locked
  • Question
Report header totals
Replies
1
Views
221
dhookom
dhookom
Kennelbloke
  • Locked
  • Question
Problems with image on report 1
Replies
8
Views
628
dhookom
dhookom
lameid
  • Locked
  • Question
The Never shrinking whitespace problem 1
Replies
6
Views
392
lameid
lameid
Lhuffst
  • Locked
  • Question
problem passing dates
Replies
2
Views
241
Lhuffst
Lhuffst

Part and Inventory Search

Sponsor

Back
Top