First customer record only

[nate]

I have an enrollment database for a summer camp. The users requested that I create a report that shows the students name and the first camp they have enrolled in for the summer (so they know who is new or not.)

The database is broken down into Season>Week>Classes and I've got so far as to have a query which shows the fields;

SeasonName, ClassName, StartDate, StudentName

However, most students are enrolled in more than one class over the summer, so they repeat under student name. Essentially what I need to do is have a only the first record of StudentName appear, for each SeasonName, using the StartDate as the guide.

Can anyone think of a way I could make this possible, or a link to something relevant?

 

[pbaldy]

Sounds like this would work, using Min instead of Max:

http://www.baldyweb.com/LastValue.htm