Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need to return a maximum number of records while accepting duplicates

Status
Not open for further replies.

chrisgeek

Technical User
Oct 16, 2008
25
US
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top