<div>
Hi,<br />
<br />
Change the query to group by<br />
Put [ID] as a count field in the query<br />
Make criteria &nbsp;[PublicActivityCode]=&quot;GT&quot;<br />
<br />
Regards,<br />
<br />
Bill
</div>


Hi,

Change the query to group by
Put [ID] as a count field in the query
Make criteria  [PublicActivityCode]="GT"

Regards,

Bill

<div>
Hi,<br />
<br />
You can also create a field using the expression <br />
<br />
dcount(&quot;ID&quot;,yourtable,&quot;Pub<wbr />licActivit<wbr />yCode='GT'<wbr />&quot;)<br />
<br />
but this will be slower.<br />
<br />
Regards,<br />
<br />
Bill
</div>


Hi,

You can also create a field using the expression

dcount("ID",yourtable,"PublicActivityCode='GT'")

but this will be slower.

Regards,

Bill

<div>
FYI - ABS is not required. &nbsp;Count can never be &lt;0.
</div>


FYI - ABS is not required.  Count can never be <0.

<div>
<div class="content wysiwyg-content">
Using query designer I have this code:<br />
<br />
TouringCount: Abs(Count([ID]) And [PublicActivityCode]=&quot;GT&quot;)<wbr /><br />
<br />
Which doesn't work. &nbsp;I'm trying to count the records (ID) where PublicActivityCode] = &quot;GT&quot; or &quot;ST&quot;.<br />
<br />
It needs to be an expression because I have more of these types of fields to add.
</div>
</div>


Using query designer I have this code:

TouringCount: Abs(Count([ID]) And [PublicActivityCode]="GT")

Which doesn't work.  I'm trying to count the records (ID) where PublicActivityCode] = "GT" or "ST".

It needs to be an expression because I have more of these types of fields to add.

Expression in a query

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.