Need to return a maximum number of records while accepting duplicates

[chrisgeek]

I'm working on a subreport and I need to limit the number of records that I return. I need to return the 4 most recent entries to the 'values' field. I have already filtered it down to 5 potential items which could be found in any order when the record returns.

I think what I need to do is return all records up to a maximum of 4 records. I'm not quite sure how to do that.

Thanks for your help,

Chris

 

[CaptainD]

I have not used it yet, but have you looked into "TopN

 

[chrisgeek]

Top N Required a summary value so I had to pass on that but I'll keep it in mind for later report. Thanks for the suggestion.

I decided that I would create a group and then put the field in the group header so I would get the most recent of each group.

Thanks,

Chris