A AK May 31, 2004 #1 Hello, How to display 3 highest (smallest) values in sql query (without Max. values field) . Andrzej
M Michel Walsh May 31, 2004 #2 Hi, SELECT TOP 3 list_of_fields FROM somewhere ORDER BY FieldHoldingTheHighestWhat [ ASC | DESC ] The order by can be a list of fields, or expressions. Hoping it may help, Vanderghast, Access MVP
Hi, SELECT TOP 3 list_of_fields FROM somewhere ORDER BY FieldHoldingTheHighestWhat [ ASC | DESC ] The order by can be a list of fields, or expressions. Hoping it may help, Vanderghast, Access MVP
