SQL - Table Problem

Hi all,

I've got a database with three tables:

Student
Fields: ID, Surname, Forename, etc

Module
Fields: ID, Code, Name, Date Set, Number Of Marks Available, etc

Student Module
Fields: Student ID, Module ID, Mark

So, the problem I have is getting some SQL which will either do a SELECT or perhaps a CREATE which will leave me with a table like this:

Student 1 Mark for Module 1 Mark for Module 2 Mark for Module 4 Mark for Module 3... ...Mark for Module n
Student 2 Mark for Module 1 Mark for Module 2 Mark for Module 4 Mark for Module 3... ...Mark for Module n
Student 3 Mark for Module 1 Mark for Module 2 Mark for Module 4 Mark for Module 3... ...Mark for Module n
...
...
Student m Mark for Module 1 Mark for Module 2 Mark for Module 4 Mark for Module 3... ...Mark for Module n

Where n is the number of modules and m is the number of students.

Any ideas?

Thanks a lot for your time.

Regards,
Louis Rose.