I have a table with categories as follows
profileid, categories
1224 abstract
234 illustration
2345 abstract
4 drawing
56 sculpture
This code works and creates me a list of categories.
Expand|Select|Wrap|Line Numbers
- SQLQuery = "SELECT DISTINCT tblA.categories" _
- & " FROM tblA" _
- & " where tblA.profileid<>'' " _
- & " ORDER BY tblA.categories asc"
what I need the query to do now is to include only the 10 most used categories.
Any help would be great.
Thanks
Richard