Phucon,
You can add a text box in the Department header:
Name: txtDeptCount
Control Source: =1
Running Sum: Over All
Sent: Friday, February 3, 2017 9:12 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Grouping and Sum on a report
I am working on a report which contains company name, department name and employees... The report has the format as shown below. My current task is to add a total that counts the number of Departments.
I placed a text box in the Department Footer and have the control source as =count([Department]). However, it looks like it's totaling the number of employees not the department. What is the correct way to handle this?
Phucon.
Company 1
Department 1
Employee Name First Mi Last
xxxxxxxxxx x xxxxxxxxxx x xxxxxxxxxx
xxxxxxxxxx x xxxxxxxxxx x xxxxxxxxxx
xxxxxxxxxx x xxxxxxxxxx x xxxxxxxxxx
Total Department: 1
----------------------------------------------------------------------
Company 2
Department 1
Employee Name First Mi Last
xxxxxxxxxx x xxxxxxxxxx x xxxxxxxxxx
xxxxxxxxxx x xxxxxxxxxx x xxxxxxxxxx
xxxxxxxxxx x xxxxxxxxxx x xxxxxxxxxx
Department 2
Employee Name First Mi Last
xxxxxxxxxx x xxxxxxxxxx x xxxxxxxxxx
xxxxxxxxxx x xxxxxxxxxx x xxxxxxxxxx
xxxxxxxxxx x xxxxxxxxxx x xxxxxxxxxx
Total Department: 2
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 (4) |
Tidak ada komentar:
Posting Komentar