If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I do a summary of my records
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. |
Thread Tools | |
Display Modes | |
|
|