troubleshooting Question

Access 2007 - How do I create a cumulative sum for a field in a number of records

Avatar of swan_solutions
swan_solutionsFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft Access
8 Comments1 Solution582 ViewsLast Modified:
I have an SQL database which is the backend for my helpdesk system.
I need to do some reporting and need some advice.

I have a report which will take data from various tables.
I have created a query to show the following

TICKET_ID
BILLING_MINUTES

This returns a number of rows similar to the info below

TICKET_ID     BILLING_MINUTES
101100          60
101100          30
101100          30
101101          60
and so on. . . .

I want the query to return a sum for each TICKET_ID such as..
101100          120
101101          60

You advice on how to do this is apprciated.


ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros