469,626 Members | 1,046 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,626 developers. It's quick & easy.

count in a report

1
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 1715
BradHodge
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 this site, you agree to our Privacy Policy and Terms of Use.