Prev: test
Next: Make Table query, but remove character from field
From: amr on 5 May 2010 05:34
in query i want to get product ID with the Max. or Min. price
From: John Spencer on 5 May 2010 08:00
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

amr wrote:
> in query i want to get product ID with the Max. or Min. price
 | 
Pages: 1
Prev: test
Next: Make Table query, but remove character from field