It's easy to get Top Values for a query -- but HOW do you get Top Values for a query that is grouped? It's not very straight-forward, but not very hard either, using a SubQuery SELECT statement. Get the Top 5 Companies By Revenue for each Employee.
related video:
Using TOP values in a Query ~ DataPig
• Using TOP Values in an...
This video has been resurrected from an older Access tutorial series by DataPigTechnologies. Even though Access looks different now, the concepts and functionality persist. Thanks to owner, Mike Alexander, for making these videos available for presentation once again. Thanks also to Jack Drawbridge and John Clark for helping get these valuable lessons back online.
Негізгі бет Ғылым және технология Get Top Values per Group using a Subquery in Access ~ DataPig
Пікірлер: 7