I have a database set up but now I would like a summary of some different
items such as how many manholes have been input from each of the 19 areas. I
am trying to figure out how to make the calculations and display them.

I have a query that gives me a list of areas and how many manholes are in
each area but I cant seem to figure out how to get that information into a
form or report.

This is what my query SQL looks like

SELECT Inspections.Area, Count(Inspections.Area) AS NumMH
FROM Inspections
GROUP BY Inspections.Area;

Am I going about this the wrong way? Would a better idea be to use a form
and make the record source Inspections and then On Load write code that will
count the areas and then put them into designated text boxes?

Any help would be appreciated, thanks.