[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Add subtotal level to a report

Posted on 2012-09-22
Medium Priority
Last Modified: 2012-10-24
I have a report prints the transaction for each worker
Let's say worker A has 6 transactions , worker B has 4 , and so on.
I make this report
Now I need to put a subtotal for each worker (I mean the sum of Worker wage)
How come please
Question by:Mohammad Alsolaiman
  • 3
  • 2
LVL 28

Expert Comment

ID: 38424594
When creating the report, group by worker. It will total each worker automatically.

Chris B

Author Comment

by:Mohammad Alsolaiman
ID: 38485060
I can figure out right now , I think my question was not so clear to you
I was mean that  i already built the report. So in this case what should I do to add subtotals without rebuild my report again from scratch
LVL 28

Expert Comment

ID: 38485227
If you provide a copy of your database here, I or someone else will correct your report.
Remove any sensitive data (names, email addresses etc), just leave a dummy sample, compact and post.

Chris B

Accepted Solution

Mohammad Alsolaiman earned 0 total points
ID: 38516754
i am very sorry for late, and very sorry for i couldn't describe my question well.
i think i already found the answer
please fallow the steps in illustrating photo

Author Closing Comment

by:Mohammad Alsolaiman
ID: 38529336
maybe  i couldn't describe my question well.
thanks a lot for taking care , and good luck

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

872 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