HOW CAN I COUNT ALL THE GROUPS IN A REPORT

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.
 
Joined
Feb 20, 2010
Messages
12
Reaction score
0
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;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top