Selecting Database Records

[rodders45]

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?

[Nias]

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

[rodders45]

Thanks a lot!