How do I show only highest values

  • Thread starter Thread starter Patrick McKelvey
  • Start date Start date
P

Patrick McKelvey

Hi,

I have a table that contains product information. The table includes the 2
fields "Prod_Number" and "Version_Number". I want to make a query that
shows Product Numbers but limits the display to only the highest Version
Number for each product.

Who do I set the criteria?

Thanks.

Patrick.
 
Assuming Version_Number is really a number (and not text), you might try a
query whose SQL looks something like this:

SELECT
[Your Table].[Prod_Number],
Max([Your Table].[Version_Number]) AS [Highest_Version_Number]
FROM
[Your Table]
GROUP BY
[Your Table].[Prod_Number]
 
Back
Top