Accumulating values in a report

T

Tom

I have a set of records as follows:

Name Course Course_Level Credits
Bloggs AAAA 1 40
Bloggs AAAA 2 40
Bloggs AAAA 3 20
Smith AAAA 1 10
Smith AAAA 2 10

I want to report on the above as follows:

Name Course Level1 Credits Level2 Credits Level3 Credits
Bloggs AAAA 40 40 20
Smith AAAA 10 10

How to I formulate my report to achieve this?

Any help would be greatly appreciated.

Tom
 
Top