Creating a Spreadsheet-like Report

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

I have a table of students' marks. Looks something like
this:
StudentID Subject Mark
111111 Math A
111111 Science B+
111111 Social B-
111111 Phy Ed B+
222222 Math C+
222222 Science A
222222 Social B-
222222 Phy Ed C
etc.

I need to create a report that looks like this:
StudentID Math Science Social Phy Ed
111111 A B+ B- B+
222222 C+ A B- C

Is there a way to do this in Access 2002?

Bruce
 
Bruce said:
I have a table of students' marks. Looks something like
this:
StudentID Subject Mark
111111 Math A
111111 Science B+
111111 Social B-
111111 Phy Ed B+
222222 Math C+
222222 Science A
222222 Social B-
222222 Phy Ed C
etc.

I need to create a report that looks like this:
StudentID Math Science Social Phy Ed
111111 A B+ B- B+
222222 C+ A B- C

Is there a way to do this in Access 2002?
Click to expand...

The easiest way would be to create a crosstab query. The
row heading woulf be studentid, column heading is subject
and use First for mark.
 
Back
Top