Ramon Quintana

Ramon Quintana

  • 1.7k
  • 404
  • 45.2k

I want to count records

Apr 17 2019 11:40 AM
Hi i used this sql to get this information:
 
SELECT Cuentas_Maestro.Functional_Area, Area_Funcional.Functional_area_Desc
FROM Area_Funcional INNER JOIN Cuentas_Maestro ON Area_Funcional.Functional_area = Cuentas_Maestro.Functional_Area
WHERE (((Area_Funcional.Tipo_de_costo)="costo"))
 
 
 
Notice that there are more than 2 codes in the camp1, so i want to group thay camp in order to know how many records have code 7010 and how many code have 7011.
 
Some SQL command to add in my initil query?
 
Thanks for help.

Answers (2)