Grouping on Similar Data

[samusa]

Hi All,
I've been trying to accomplish this and can't seem to find a direction. Can someone please get me started or at least point me in the right direction.

I have a table structured like the one below:
ID StudentID LastName FirstName Title StartDate EndDate

1 1 Smith John GroupLeader 1/1/2005 3/1/2005
2 1 Smith John Leader 4/1/2005 6/1/2005
3 2 Brown Salley Team Manager 3/1/2005
4. 1 Smith John GroupLeader 7/1/2005

I have created a query that is grouping by the FIELD StudentID.However while creating report based on this query poping everythging in duplicates.Can someone tell me how get report like this.


StudentID: 1 LastName : Smith FirstName:John

Title StartDate EndDate
GroupLeader 1/1/2005 3/1/2005
Leader 4/1/2005 6/1/2005
GroupLeader 7/1/2005



StudentID: 2 LastName : Brown FirstName:Salley

Title StartDate EndDate
Team Manager 3/1/2005

Appreciate your help

Sam

 

[PHV]

Base your report on the table and create a GroupLevel for StudentID

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886