Mr. Southern
Registered User.
- Local time
- Today, 08:21
- Joined
- Aug 29, 2019
- Messages
- 90
Hello,
So I think I need to do a Top Value Query by Group but cannot figure it out.
I have a query that is called qry_Stop with two columns (AccountNumber:Right([LOCATION],8) and R_Date). Neither are sorted or totaled. I used the Right function because I needed to only get 8 of the numbers from the right.
I would like to find the 5 most recent entries per AccountNumber using the R_Date.
Does anyone have any tips or ideas on how I should move forward?
So I think I need to do a Top Value Query by Group but cannot figure it out.
I have a query that is called qry_Stop with two columns (AccountNumber:Right([LOCATION],8) and R_Date). Neither are sorted or totaled. I used the Right function because I needed to only get 8 of the numbers from the right.
I would like to find the 5 most recent entries per AccountNumber using the R_Date.
Does anyone have any tips or ideas on how I should move forward?