How do I do a summary of my records

  • Thread starter Thread starter dannie
  • Start date Start date
D

dannie

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.
 
Or make a repor that groups by inspection areas and (untested) put a box the
group footer with a control source of =sum([area])
 
How do I put the data into the text boxes on the form? Right now what the
query displays when you run it is

Area NumMH
0
APCB 16
APD3 8
APDF 2
APDG 6
APFH/CH 16
APP1 4
GODU 12
GOL2 3
GOL4 6
GOLM 6
GOOF 23
GOSO 14
GOWC 23
MECH 48
 
How do I put the data into the text boxes on the form? Right now what the
query displays when you run it is
Click to expand...

Create a Form based on this query; if appropriate, use it as a Subform on the
main form. (If you do so, using Continuous Form view might be most
appropriate).
 
Back
Top