I want to count records

Question

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.