COUNT IN SQL QUERY

[sal21]

I use this query to count value in field

Code: Select all

SELECT RDT, RDTAB, COUNT(EI) AS SOMMAMD FROM L0928 GROUP BY  RDT, RDTAB

but based the joint of rdt&rdtab i need to count all field ei,up,ci,ep
how to?

[HansV]

Just add a comma and COUNT(fieldname) for each field that you want to count.

Keep in mind that COUNT(fieldname) will return the number of records with non-blank values in that field. If the fields are all filled in, the count will be the same for all fields.

[sal21]

Just add a comma and COUNT(fieldname) for each field that you want to count.

Keep in mind that COUNT(fieldname) will return the number of records with non-blank values in that field. If the fields are all filled in, the count will be the same for all fields.

???, sorry

ahhhhhhhhhhhhhhh. resolved.
Tks.

But i need to return in other column the joint rdt&"-"&rdtab, is posible?

this is my sql:

Code: Select all

SELECT L0928.RDT, L0928.RDTAB, Count(L0928.EI) AS SOMMAMDEI, Count(L0928.UP) AS SOMMAMDUP, Count(L0928.CI) AS SOMMAMDCI, Count(L0928.EP) AS SOMMAMDEP
FROM L0928
GROUP BY L0928.RDT, L0928.RDTAB;

[HansV]

Here is the SQL for a query based on the Orders table in the Northwind database that counts three fields by employee:

SELECT fkeyEmployeeID, Count(fkeyCustomerID) AS CountCustomers, Count(fkeyShipVia) AS CountShipVia, Count(curFreight) AS CountFreight
FROM tblOrders
GROUP BY fkeyEmployeeID;

Here is the query in design view:

x370.png

And in datasheet view:

x371.png

As you see, the three count fields have the same numbers in the first row, and also the same numbers in the second row, etc.

[sal21]

Here is the SQL for a query based on the Orders table in the Northwind database that counts three fields by employee:

SELECT fkeyEmployeeID, Count(fkeyCustomerID) AS CountCustomers, Count(fkeyShipVia) AS CountShipVia, Count(curFreight) AS CountFreight
FROM tblOrders
GROUP BY fkeyEmployeeID;

Here is the query in design view:

x370.png

And in datasheet view:

x371.png

As you see, the three count fields have the same numbers in the first row, and also the same numbers in the second row, etc.

Note:
Can you add in icon menu of post the "pasta" and "pizza" for my personal use