472,098 Members | 2,561 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,098 software developers and data experts.

count in a report

I have a report based on a query. I list an Org_Type then Org_Name then the Projects associated with it. Sample of report below:

Community Type
---------------------------------------------------------Org_Type Header
Org_Name bla bla bla
project a
project b
project c
-----------------------------------------------------------Org_Type Footer
(=Count(*) & " Records")

-----------------------------------------------------------Report Footer
(=Count(*) & " Records")

I have a count set up in the organization type FOOTER (=Count(*) & " Records"), and a overall count in the report FOOTER (=Count(*) & " Records"). I'm getting the Count for the number of Projects associated with each Org_Name. I don't want the Projects counted, I want the Org_Names counted. The reason I have the count in the Org_Type Footer, is so it counts a subtotal for all Org_Names that fall under the Org_Type. If I put the count in the Org_Name FOOTER, I get a subtotal after each Org_Name. This I don't want. How can I get the subtotal of all Org_Names while leaving the Count in the Org_Type FOOTER??? It should look like this:

Academic Type
Org_Name bla bla bla
project a
project b
Org_Name bla bla bla
project c
SUBTOTAL = 2 (not 3) (should count names not projects)

Is there a way like =count(some specific field)????
Nov 21 '07 #1
1 1795
166 Expert 100+
Take a look at this post and see if it gets you going in the right direction.

Welcome to theScripts!
Nov 21 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by wilscott1st | last post: by
3 posts views Thread by Miguel | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.