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.

You are on the right track. Instead of "COUNT," try "SUM."

Cheers

"dannie" wrote:

> 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

"MPM1100" wrote:

> You are on the right track. Instead of "COUNT," try "SUM."
>
> Cheers

On Thu, 4 Feb 2010 08:25:01 -0800, dannie <(E-Mail Removed)>
wrote:

>How do I put the data into the text boxes on the form? Right now what the
>query displays when you run it is

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).
--

John W. Vinson [MVP]