View Single Post
  #4  
Old February 4th, 2010, 04:25 PM posted to microsoft.public.access.tablesdbdesign
dannie
external usenet poster
 
Posts: 25
Default How do I do a summary of my records

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