Query Assistance

[PeteBWhat]

Hi, folks -- was hoping someone could shed some insight on how I can write this query.

I'm working on an application that will interface with an MS Access Database that's dumped from a system that's used to track student internships. The first few columns in the database are as follows:

Rec_ID, Org_ID, Term_Code, Reg_Term_Description, Major, Org_Description

I've written a query that will go through and select all internships within an organization by distinct major, but I'm trying to figure out how to return the number of internernships within that organization for that major (there may have been two during one term, or one for the past four terms):

SELECT DISTINCT(Major), Org_Description FROM tbl_website_download ORDER BY Major

Any help would be greatly appreciated!

[tomhath]

SELECT Major, Org_Description, count(*) as num_internships
FROM tbl_website_download
GROUP BY Major, Org_Description