Need query help - MAX record

• jmerlau

  Valued Member

  Points: 65

  More actions

  May 12, 2025 at 1:16 pm

  #4590209

  I am having trouble writing linking the MAX query that I created back to the table to produce other data elements about the MAX record.  I have created a Word document showing an excerpt from the main data table, how the MAX query pulls in the appropriate records, but then I am stumped on how to create a query joining the MAX table back to the main table to get another data element out.  Any assistance would be greatly appreciated.  Thanks!

  Attachments:

  You must be logged in to view attached files.

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  May 13, 2025 at 2:10 pm

  #4590664

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• pietlinden

  SSC Guru

  Points: 63572

  More actions

  May 13, 2025 at 3:46 pm

  #4590714

  Welcome to SSC.  I think your question needs some help.  One thing that's a challenge when you first start out is knowing how to ask a question that will get answered. Fortunately, Jeff Moden wrote an article about it. Please read it and follow the instructions outlined in it so that we can help you.

  You don't mention what your ultimate goal is. Return the MAX of a column? (Can you be more specific? Give an example?). If the logic to accomplish it is not immediately obvious, please explain it.

  Also, please put all the explanation and the scripts (CREATE TABLE, SELECT, INSERT...) directly into your post on here (just use the CODE button for that). That way people here can quickly see what you're starting with and quickly answer your question. The way I like to do it is like this:

  1. explain (briefly) what you're trying to accomplish... and what the solution should look like.
  2. provide enough data (create tables, inserts) to recreate your problem
  3. explain what you tried.