How to count the same field value from a query field and show the result in a report?

[Jahangps]

Hi Experts,
I am very new at MS Access. Pls look at following Query:


QUERY:1

STUDENT'S ID	JANUARY	FEBRUARY	MARCH	TOTAL
1	100	100	100	300
2	0	100	100	200
3	125	125	0	250
4	100	100	100	300
5	100	0	100	200
6	125	0	125	250
7	0	100	100	200

Here in 'JANUARY' field, 100 occurs 2 times, 125 occurs 2 times.
Here in 'FEBRUARY' field, 100 occurs 4 times, 125 occurs 1 time.
Here in 'MARCH' field, 100 occurs 5 times, 125 occurs 1 time.
Here in 'TOTAL' field, 200 occurs 3 times, 250 occurs 2 times and 300 occurs 2 times.

Now I would like to show it in a report like following;
REPORT:1

MONTH	JANUARY	100	125	FEBRUARY	100	125	MARCH	100	125	TOTAL	300	250	200
OCCURING TIMES	--------	3	2	----	4	1	----	5	1	----	2	2	3

Pls, help me in making the report. Thanks to all.

[June7]

Is that a CROSSTAB query? Building a report to run perpetually based on a CROSSTAB can be difficult. Do you have multi-year data in this db?

I see 3, not 2, 100 under January.

That is a very 'out of the ordinary' report structure. I don't think a query alone can do that. Probably require VBA and writing records to a temp table.

[Jahangps]

Yes, It should be 3, not 2, under January. Now I edited it. Thanks to June7.

[Demerit]

It is possible to reproduce a report like the one above except you will have to deal with alot of VBA.

I mean alot, starting from an unbound form to the report concern