Beginner: how would I display this in access?

[ndeer44]

So for simplicity say i have a table with 2 columns, one with names, other with numbers. I want to be able to filter by the names and say like how many numbers = 1, 2, 3....etc and find the average of all those numbers for that name. I know this can be done manually, but I am trying to do it automatically like in a form or a report. I have been able to use a report and set label text to count all of the 1s using DCount, but I am not sure how to filter for a certain name and then do a DCount?

[Robeen]

Do you want to do this in a Query?