How do i get the product of max. price in access2007 query?

  • Thread starter Thread starter amr
  • Start date Start date
The SQL statement for a query to do that would be

SELECT ProductID
FROM SomeTable
WHERE Price = DMax("Price","SomeTable")

OR

SELECT TOP 1 ProductID
FROM SomeTable
ORDER BY Price DESC

IF you need something more specific post more details on what you are
attempting to do.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 

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

Parameter Query on an expression 8
Last Date 3
return product with maximum price 6
Finding max value 3
Does not include the specified expression as part of an aggregatefunction 2
Update query help 2
query too slow 1
Query 2

Back
Top