Hi,
does some one knows how to show the most used items items from a table??
like:

yellow
green
blue
yellow
yellow
green

the thing i have to see is the most used color. In this case it is yellow.

Please help me.

SELECT TOP 1 tblYourTableName.Color, Count(tblYourTableName.Color) AS CountOfColor
FROM tblYourTableName
GROUP BY tblYourTableName.Color;

In your case, this will return

Color CountOfColor
yellow 3

HTH

mmcdonal

Thanks it works!!!