TADIS Posted June 15, 2006 Share Posted June 15, 2006 Hi, can someone help me on a problem please?I have an access database linked up to an application designed in VB.NET. I am trying to implement a query where it sorts a list of books. Basically I am trying to find the top ten books borrowed between any given date. How would I check a column to find the top ten most borrowed books? I have tried several queries but none seem to work! Please Help..Ahmed Link to comment Share on other sites More sharing options...
aspnetguy Posted June 15, 2006 Share Posted June 15, 2006 I am moving this tot he SQL forum.Please post the code that you have already and provide the schema for the database table in question. Link to comment Share on other sites More sharing options...
netcracker Posted June 15, 2006 Share Posted June 15, 2006 something like this??? sql.open (select * top 10 from BOOKS where DATE between #& now() and #& now() - 7 order by BORROWED desc), conn Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now