Query that will find most used # in any order

[webware]

I need a query or maybe vbscript that will search my database without having a user input a # for a 3 digit # in any combination that was most freaquently used,2nd most freq. etc. for example: if the database contains 7 entries 325; 352; 235; 253; 532; 523; 234, the output should show that the most freq. used was 3 #'s containing 325. Can anyone help me with this? I am using microsoft access2002....I have tried a query using LIKE but I dont want the user to have to input a #... I am really a designer not a programmer so...Thanks to anyone who can help.

 

[raskew]

Test this in Northwind and see if it's what you are after. It categorizes the Quantity field in table Order Details and returns the most frequent order quantity.

SELECT top 1 Count([Order Details].Quantity) AS CountOfQuantity, [Order Details].Quantity
FROM [Order Details]
GROUP BY [Order Details].Quantity
ORDER BY Count([Order Details].Quantity) DESC;

To see the entire listing, remove 'top 1' from the first line of the SQL.