<div>
Please close question - I found a more or less similar question here <a href="https://www.experts-exchange.com/questions/27838289/MS-Access-Top-N-per-Group-and-Totals.html" rel="ugc"></a>
</div>


Please close question - I found a more or less similar question here https://www.experts-exchange.com/questions/27838289/MS-Access-Top-N-per-Group-and-Totals.html

<div>
You have to close the question. &nbsp;Please try again. &nbsp;Just accept your own answer although posting a link to the actual answer would be helpful to others.
</div>


You have to close the question.  Please try again.  Just accept your own answer although posting a link to the actual answer would be helpful to others.

<div>
<div class="content wysiwyg-content">
Running Access 2010/2013/2016 - I'm having trouble making a Query, getting the Top 5 tasting-scores from the table containing the fields shown below <br />
<br />
It needs to return an average of the TastingEvalScore, of the 5 latest TastingDate's for each of the ProductID's, together with a Count of TastingID's (to see if the average was based on 5 or less tastings)<br />
<br />
Table: tblTasting <br />
Fields: ProductID, TastingDate, TastingEvalScore, TastingID
</div>
</div>


Running Access 2010/2013/2016 - I'm having trouble making a Query, getting the Top 5 tasting-scores from the table containing the fields shown below 

It needs to return an average of the TastingEvalScore, of the 5 latest TastingDate's for each of the ProductID's, together with a Count of TastingID's (to see if the average was based on 5 or less tastings)

Table: tblTasting 
Fields: ProductID, TastingDate, TastingEvalScore, TastingID

Query getting average and count from Top 5 on group

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.