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

[amr]

in query i want to get product ID with the Max. or Min. price

 

[John Spencer]

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