I have a database with a bunch of records, now I want to summarize this info. I made a query that is written like;
SELECT Inspections.Area, Count(Inspections.Area) AS NumMH
FROM Inspections
GROUP BY Inspections.Area;
and produces something like ;
Area NumMH
0
APCB 16
APD3 10
APDG 6
I want to get that information into text boxes in a form but I dont know how to extract the information because each row isnt a record and I would like to be able to use the Area to associate with the NumMH Any help would be appreciated, thanks.