This is hopefully a simple one.
How can I count records based on criteria? So it would be a count of 'Active' ('Status' Field) for each 'Group'.
I'm looking to go from something like this:
<tbody>
</tbody> etc....
To this:
<tbody>
</tbody>
I've tried the below as a field in the query but it returns the wrong numbers:
[FONT="]
[/FONT]
How can I count records based on criteria? So it would be a count of 'Active' ('Status' Field) for each 'Group'.
I'm looking to go from something like this:
Group | RecordID | Status |
ABC | 0001 | Active |
ABC | 0002 | Closed |
ABC | 0003 | Active |
DEF | 0004 | Active |
<tbody>
</tbody>
To this:
Group | Active Records |
ABC | 13 |
DEF | 25 |
<tbody>
</tbody>
I've tried the below as a field in the query but it returns the wrong numbers:
[FONT="]
Code:
[/FONT][/COLOR][COLOR=#2F2F2F][FONT="]=DCount("[Group]", "tblRecords", "[SalesStatus] = 'Active'")[/FONT][/COLOR][COLOR=#2F2F2F][FONT="]
[/FONT]
Last edited: