Access query

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I have a table in my database which has several records for each
student. Each record lists each test taken in a separate record.

Smith John ACT
Smith John SAT
Smith John PSAT

My client wants to create a query which only has 1 record per student.
Granted that it will have lots of wasted space as I have to include 10
iterations of the test for each student, but the client wants it.

Is there a way to make a query which makes the data look like

Smith John ACT SAT PSAT blank blank etc


Thanks in advance for the help

Jeff
 
Back
Top