Skip to Content
0
Former Member
Aug 29, 2008 at 02:59 PM

Only view first record in Group#2

23 Views

I have two groups. Let's call Group#1-Fruits. Group#2 includes Apples, Oranges...

In the details section of Group#2, I only want to pull the first record (which will be the most recent date because of the sort I set up). For example, Group#2 will show Apples, with the detailed records including Green - 7/5/08, and Red - 6/1/08. I will only want to see "Green 7/5/08".

I am suspecting this may require a subreport, but I am not sure how to go about just viewing the first record. I also played around with Group Sort Expert, but I am a newbie and just figuring it out as I go along... Any help is appreciated.