Joined: 12 Apr 2018
Location: United States
Online Status: Offline
Posts: 1
Topic: How to limit results to 5 most recent transactions Posted: 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?
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 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.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
