Selecting Database Records

I have an Access database with a field in called 'Category'. This field contains several records with the same value, e.g

CATEGORY
News
News
News
Games
News
Games
Games
Games

What I want to do is get a list of all the different category names using ASP. How do you do it?

Try "Select Distinct Category FROM ..." in your query string. This should return 2 rows with NEWS and GAMES.
That help?

Thanks a lot!