HOW CAN I COUNT ALL THE GROUPS IN A REPORT

  • Thread starter Thread starter wmontes.endozo
  • Start date Start date
W

wmontes.endozo

Hi guys please help me.

Below is my report

S/n Hours CODE

1 -------4------------A
2--------8------------B
3--------12-----------C
4--------3.5----------A
5--------1.1----------A


I want my report to group and count the value

A=3
b=1
c=1


Thank you guys in advance.
 
Set up your query to count S/N and group by Code:

SELECT tblYourTable.Code, Count(tblYourTable.SerialNumb) AS CountOfSerialNumb
FROM tblYourTable
GROUP BY tblYourTable.Code;
 
Back
Top