Go Premium for a chance to win a PS4. Enter to Win

x
?

ms access query top 5 by group and corresponsding top 3 results

Posted on 2017-11-14
1
Low Priority
?
18 Views
Last Modified: 2017-11-14
Hi there:

I am trying to get the top 5 problemcodes_nonus and only the corresponding top 3 conclusioncodes_nonus for each complaintmonth.  Table and query in attached db.

Many thanks!

SG
Database1.accdb
0
Comment
Question by:sxxgupta
1 Comment
 

Author Comment

by:sxxgupta
I figured it out.  Requesting to close
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Join & Write a Comment

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

963 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question