Choose Entire Row with Max Date Based on Measure ID
I have a problem in which i do not know the most efficient way of solving it I believe we would need some vba code to solve it, however i do not have much programming skills. I've visualized my problem in the attached PDF to explain exactly what i mean with sample data, i hope it makes sense. I have the data set in an Access table. I would really appreciate a solution with a bit of explanation as to the steps/logic taken so i can learn. Again thanks alot experts i trully appreciate it.
Thanks Experts.
Problem-Visualized9.pdf
Thanks Experts.
Problem-Visualized9.pdf
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
chaau
@capricorn1: not in MS Access
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
oh yes, you can do that in access
@capricorn1: Have you tried this? I have tried it right now with a simple query and it gave me 'Error in JOIN operation'
ASKER
Thank you all for the fast replies and answers i really appreciate it im learning alot from you guys, i will try the solutions tomorrow at work and yes i am using access 2003.
@chaau
https://www.experts-exchange.com/questions/22517478/Need-HELP-to-query-the-LATEST-dates.html?anchorAnswerId=18928140#a18928140
https://www.experts-exchange.com/questions/26953763/Access-Query.html?anchorAnswerId=35394503#a35394503
https://www.experts-exchange.com/questions/28007355/SQL-Determine-Last-Customer-Sales.html?anchorAnswerId=38815063#a38815063
https://www.experts-exchange.com/questions/25997460/Get-value-of-other-fields-from-Max-date.html?anchorAnswerId=31406549#a31406549
https://www.experts-exchange.com/questions/22517478/Need-HELP-to-query-the-LATEST-dates.html?anchorAnswerId=18928140#a18928140
https://www.experts-exchange.com/questions/26953763/Access-Query.html?anchorAnswerId=35394503#a35394503
https://www.experts-exchange.com/questions/28007355/SQL-Determine-Last-Customer-Sales.html?anchorAnswerId=38815063#a38815063
https://www.experts-exchange.com/questions/25997460/Get-value-of-other-fields-from-Max-date.html?anchorAnswerId=31406549#a31406549
ASKER
Those are good references capricorn let me check them out. I appreciate it.
ASKER
Thank you all for your expertise i learned alot. I appreciate it
Welcome!