Phucon,
If you want assistance from anyone other than John who has a great memory, you will need to include the previous pertinent information in your posts to the group.
There are ways of accomplishing what you want by either including a totals query in your report's record source or possibly using running sums. I can't tell because your previous emails in this thread have been deleted from my inbox.
It would really help if you took the time to post some sample data in sections of your report and describe the totals you expect.
Regards,
Duane
Switzerland
Sent: Wednesday, February 8, 2017 2:33 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Grouping and Sum on a report
Hello Mr. Viescas
It looks like it's counting or summing the total employees. For example, Company A has 2 departments, department A and B. Each department has 5 employees. The total will show 10. If the company has only 1 department, and there are only 2 employees with that department, it will show 2.
Phucon
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (9) |
Tidak ada komentar:
Posting Komentar