MAX Query

[pony08]

I am looking for a query that will single out a SKU with the maximum number of sales. I have a table that shows a SKU's material code, sales and SKU number. What I need the query to do is find the MAX sales, (1831 in the below instance) and return only the line with 0CXX2005300CP.


Material Code / Sales / SKU
0CXX20053000P / 0 / 00CXX20053
0CXX2005300CP / 1831 / 00CXX20053
0CXX2005300BT / 580 / 00CXX20053

 

[billmeye]

Try this:

SELECT *
FROM tblSKU
WHERE (((tblSKU.Sales)=DMax("[Sales]","tblSKU")));

This will return 1 or more rows depending on any ties.

 

[pony08]

Thanks....I will give it a test drive!