Hai ..

I am trying to use select method to view the access database result using ASP

My problem is :


I am searching a book title "intro"

There is a book (the same book) but different ID number

Can result only show one result and by clicking the result it will show all the book ID ?

Can I ?

I'm not entirely sure what you mean but if you just want to return one using select:

select top 1 * from <tablename> where <field> = <filter>

Hope this helps.