Simple access situation

[Xi0N]

Im quite new to the use of sql, and i have this problem right now:



I have two tables:

Schools
Students

Each row in the students table has a "school_code" field that corresponds with a code of one school in the Schools tables.


I have to count how many students are there in each school: Basically, i should do a new query with the entire table "Schools" and add one more field with the number of students in each school......

Can anyone tell me how can i do this? For me is quite difficult to guess it right now, and i have a bit of an urgency with this.


thanks!

[SoftwareMatters]

Create a new query and add the Schools table. Double-click the school_code field to bring it in to your query. Put a GroupBy on and change the Total to Count.