showing distinct records with all school information

[wsproperties]

I have an access query. I pull in the name.ID and link it to the school_table.id. Here is the issue. A person can have more than 1 school degree (which is taken from the school_table) I want to show the name.ID one time or distinct.

In an access query,
I want to show all the degrees. Right now if a person has 3 school degrees, the name will show up 3 times. Is there a way in a query to show the name once but show each degree in its separate field horizontally? Is this beyond Access?

 

[PHV]

Have a look here:
faq701-4233

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886