SELECT DISTINCT company_code.department, " _
& "courseCat.link_name " & _
"FROM company_code " & _
"INNER JOIN courseCat ON company_code.group_id= courseCat.group_id " & _
"WHERE courseCat.company_id = " & company_id & _
"GROUP BY company_code.department, courseCat.link_name" & _
" ORDER BY courseCat.link_name

The code above will print the department and link_name on each row.
i.e. Department 1
Course 1

Department 1
Course 2
etc.

Does anyone know how I would write the code to print the department as a header followed by the associated link_name? i.e.
Department 1
course 1
course 2

Department 2
course 1
course 2

etc..

Can't be done.

SQL returns resultsets which are a homogenous collection of rows all with the same columns. Each row, of course, has distinct values, but every row is structurally identical to every other row.

You are asking that the rows be different.

Your problem is best handled at the client...

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Jeff, that gave me another idea. I split the query into 2 separate queries and iterate through the course listings until EOF and then jump back to the first query to grab another department and iterate through the 2nd query again until EOF. It works perfectly.