Group output with all values in 3 diferent fields

Hi,

I am trying to write a query with the results going to a report builder report. One student can have up to 3 records. Each record contains a code and a boolean field or a date field. If these records are present I want to show the results on one line in the report.

Input:

A HI 1

A PD 0

A JP date

B PD 1

C HI 1

C JP DATE

Output desired (each in it's own field):

A 1 0 date

B '' 1 ''

C 1 '' date