randolphoralph
Registered User.
- Local time
- Today, 16:12
- Joined
- Aug 4, 2008
- Messages
- 101
I am trying to get the top 10 from a query and can not seem to get what I need.
Table Name: New
Field Names:
GRP NAME (text)
GRP ID (text)
AMMS (text)
COUNT OF AMMS (Number)
I am trying to trying to display the Top 10 for each GRP NAME, GRP ID, AMMS based on the top 10 with the highest COUNT OF AMMS.
So as a before example...
GRP NAME GRP ID AMMS COUNT OF AMMS
SAD 879 FDD 15
SAD 879 ADF 14
SAD 879 FCD 13
SAD 879 ABC 12
SAD 879 GFD 11
SAD 879 GTH 10
SAD 879 HNJ 9
SAD 879 QDW 8
SAD 879 PJK 7
SAD 879 CVT 6
SAD 879 PLK 5
SAD 879 GOP 4
SAD 879 QMA 3
SAD 879 ZOA 2
SAD 879 CYS 1
After query for top 10 should look like this...
SAD 879 FDD 15
SAD 879 ADF 14
SAD 879 FCD 13
SAD 879 ABC 12
SAD 879 GFD 11
SAD 879 GTH 10
SAD 879 HNJ 9
SAD 879 QDW 8
SAD 879 PJK 7
SAD 879 CVT 6
It would be nice to figure out how to group GRP NAME GRP ID and AMMS at the same time.
Table Name: New
Field Names:
GRP NAME (text)
GRP ID (text)
AMMS (text)
COUNT OF AMMS (Number)
I am trying to trying to display the Top 10 for each GRP NAME, GRP ID, AMMS based on the top 10 with the highest COUNT OF AMMS.
So as a before example...
GRP NAME GRP ID AMMS COUNT OF AMMS
SAD 879 FDD 15
SAD 879 ADF 14
SAD 879 FCD 13
SAD 879 ABC 12
SAD 879 GFD 11
SAD 879 GTH 10
SAD 879 HNJ 9
SAD 879 QDW 8
SAD 879 PJK 7
SAD 879 CVT 6
SAD 879 PLK 5
SAD 879 GOP 4
SAD 879 QMA 3
SAD 879 ZOA 2
SAD 879 CYS 1
After query for top 10 should look like this...
SAD 879 FDD 15
SAD 879 ADF 14
SAD 879 FCD 13
SAD 879 ABC 12
SAD 879 GFD 11
SAD 879 GTH 10
SAD 879 HNJ 9
SAD 879 QDW 8
SAD 879 PJK 7
SAD 879 CVT 6
It would be nice to figure out how to group GRP NAME GRP ID and AMMS at the same time.