Posted By: sandballer — 16 May 2018 at 9:02am
I have a history table that includes item#, tag# (or license plate), transaction type, and date, among many other fields. How can I return only the 5 most recent transactions (or up to 5 if less than that) for each item#/tag#/transaction type combinations?
Posted By: kevlray — 24 May 2018 at 5:44am
If you are grouping you can filter by the top 5. Not sure what you would determine as the top 5. Also if the data source is a SQL and you are using a command. You can also use the TOP in the Select statement.
