Re: [MS_AccessPros] Grouping and Sum on a report

 

Phucon-

I was afraid it would do that.  You could try this:

=DCount("DepartmentID", "tblCompanies", "CompanyID = " & [CompanyID])

You'll have to fix the field names and the table name if I haven't guessed right.

John Viescas, Author

Effective SQL

SQL Queries for Mere Mortals 

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

http://www.viescas.com/ 

(Paris, France)

On Feb 8, 2017, at 9:33 PM, saigonf7q5@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

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: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (8)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___