Trouble with multi field running totals

Posted on 2011-03-15
Last Modified: 2012-05-12
I have to produce multi field running totals for the following criteria.

Area Sales Manager
Business Unit

what I'm trying to acheive is the running total for each ASM for each month for each business unit.

EE_shot1 =  is how my solution using a subquery is looking for a single ASM. It's not right.

EE_shot 2 =  the data  on which it's working upon.

EE_shot3 = My attempt to code te solution.

I would really appreciate any help I can get.

thanks, as always...

Question by:STOCRIC
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3

Author Comment

ID: 35135666
There are 7 ASM, 5 Business Units.

Accepted Solution

STOCRIC earned 0 total points
ID: 35136823
I have solved this one myself!


Author Closing Comment

ID: 35136828
I found the solution myself

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question