Access query

[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

 

[Gina Whipp]

Try:

http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16