Help with a Max and Min Criteria

[SheepDog]

I understand the concept of Max and Min for a criteria, but is there a way to bring back records that are between them as well. There are people who may have attended one class year or two class years or three class years.
Example:
Name Bob Jones 1980 High School 1984 Junior College 1986 Senior College.

I need to have the person's name and the class years they attended whether it is 1,2 or 3 years listed on the same line as their name.

 

[SkipVought]

Hi,

How is your table structured?

How does the above example fit into that structure?

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[SheepDog]

What I want is that the Person's Id, name Max to Min Class Years like below.

P000039178 Bob Jones 1951 HSG 1953 JCG 1955 SCG

 

[SkipVought]

you NEVER answered my questions!

How is your table structured?

How does the above example fit into that structure?

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884