• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 40
  • Last Modified:

Query getting average and count from Top 5 on group

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
0
Mik Mak
Asked:
Mik Mak
  • 3
1 Solution
 
Mik MakConsultantAuthor Commented:
Please close question - I found a more or less similar question here
0
 
PatHartmanCommented:
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.
0
 
Mik MakConsultantAuthor Commented:
Hi Pat - I did supply a link to the answer, but the Android App version of the site apparantly did insert it properly - I'll try again here:
similar solution
0
 
Mik MakConsultantAuthor Commented:
Found similar
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now