Query + monthly report

[tareksul]

Hello everyone, I have very little expierience with access and need some professional assistance.

I have a database that allows any teacher to make "warnings" for students who misbehave. I need a report generated every month for the school principle. It will show all the students who misbehaved during that month and sort the students from the most warning to the least.

I have a table with all the students


A table for all the teachers.

A table is made for "warnings" in which a form is used to select a students name, select the act of misbehaving, and select the complainign teacher

Thnks in advance

[pbaldy]

This type of thing:

SELECT StudentID, Count(*) AS HowMany
FROM TableName
GROUP BY StudentID
ORDER BY Count(*) DESC

You'd probably want to add a WHERE clause for a time frame, and join in the students table to get the names.

[tareksul]

This is exactly what i need, thkns.

do i copy waht u wrote and where do i paste it to?

[pbaldy]

That is SQL; you could copy/paste it into a new query in SQL view, or use the Totals icon to reveal the Totals row on an existing query. If you copy that, you'll obviously have to substitute your table and field names.