<div>
Typed in as shown but it will not let me click out of the txtbx fro some reason?
</div>


Typed in as shown but it will not let me click out of the txtbx fro some reason?

<div>
jimfive,<br />
GOt rid of the 2nd = sign. &nbsp;It works when i do this but returns a 0. &nbsp;
</div>


jimfive,
GOt rid of the 2nd = sign.  It works when i do this but returns a 0.  

<div>
Those need to be in two separate text boxes if you are using option 2.
</div>


Those need to be in two separate text boxes if you are using option 2.

<div>
WOrked when i seperated them. &nbsp;THanks for help
</div>


WOrked when i seperated them.  THanks for help

<div>
<div class="content wysiwyg-content">
What I have is a report that works off off a Query. &nbsp;I have something called a branch in the query and I break them into differnet sections on the reports. &nbsp;What I need to do is count the two branchs seperately instead of together. &nbsp;If I use =count([branch]) &nbsp;in a text box in the footer it counts them all together. &nbsp;How do I split them out to count them differently on the report. &nbsp;The 2 branch fields are &nbsp;ANG and ARNG. &nbsp;The ANG lists first on the report together then the ARNG lists. &nbsp;Thanks
</div>
</div>


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

COunt Function in Access Report

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.