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

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