Need help with Max function in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

does anyone know how to get a query to choose the maximum number only.

I have a spreadsheet that includes students and their test scores and want
the query to only list the highest score.
 
Group by the student name and then choose MAX in the test scores column.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can a Group Query Do What I need to do? 1
Finding highest values 1
DMin Built-in function in a Query 11
Compare data of column in many fields. 1
Wrong Info on Group Query 3
Vlookup type function 2
Form queries from multiple tables 4
SELECT MAX(value) from table1 and add several associated values from table2 10

Back
Top