COunt Function in Access Report

What I have is a report that works off off a Query.  I have something called a branch in the query and I break them into differnet sections on the reports.  What I need to do is count the two branchs seperately instead of together.  If I use =count([branch])  in a text box in the footer it counts them all together.  How do I split them out to count them differently on the report.  The 2 branch fields are  ANG and ARNG.  The ANG lists first on the report together then the ARNG lists.  Thanks
kdeutschAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
JimFiveConnect With a Mentor Commented:
Three options:

1.  The Normal Option, put the count in the Group Footer for the branch.  This has the benefit that when you add a new branch you don't have to change the report.

2.  The Simple Option.  In the Footer use =Sum(iif([branch] = "ANG", 1, 0)) and =Sum(iif([branch] = "ARNG",1,0)) to get the separate totals.
This has the problem that if you add a branch or change the branch code you have to redesign the report.

3.  The real Option.  Create a subreport that lists the branches and the counts.

--
JimFive
0
 
kdeutschAuthor Commented:
Typed in as shown but it will not let me click out of the txtbx fro some reason?
0
 
kdeutschAuthor Commented:
jimfive,
GOt rid of the 2nd = sign.  It works when i do this but returns a 0.  
0
 
JimFiveCommented:
Those need to be in two separate text boxes if you are using option 2.
0
 
kdeutschAuthor Commented:
WOrked when i seperated them.  THanks for help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.