Query to group and count field entries

[newtoAccess]

How do I group and count different entries that are in the same field?
I have a table that has several fields that will only have data from 1 to 5 in each field. It was a survey where the respondent chose 1 having no experience and 5 I am an expert.
I need to be able to group all the 1's, 2's,etc together then count the number of entries for each group.

[ConneXionLost]

Can you post a sample of your database?

[newtoAccess]

I don't have one yet. I have an idea on how to use data that will be arriving in a week. High school students were asked to to answer some questions rating their answers 1 no knowledge of the question to 5 I am an expert of that question.
I will build a data entry form to fill a table normal stuff. I have always had troubles with queries. There are 25 questions.

So question how many marked 1 as an answer? How many marked 2 as an answer, etc up to 5 and then the same for each of the 25 questions?
So how do I do a Query to get the above results.

[Rixxe]

You should look into the COUNT() function:

Select Field1 as "Column A" count(*) as "Column B" 
From Table1
Where
Groupby Field1

This is just an example, but sounds like the thing you need.

Good luck

[newtoAccess]

Work great for me thanks