TADIS

Hey,I am using the following code:SELECT v_Catalogue.Date_Borrowed, v_Catalogue.Title, v_Catalogue.AuthorFROM v_CatalogueWHERE (((Not Exists (SELECT Date_Borrowed FROM v_Catalogue WHERE Date_Borrowed BETWEEN ? and ?))));to try and find a list of books that have not been borrowed between a certain period (dates entered by a user: 'date from' and 'date to').The sql statement does not work properly and I am having trouble trying to get it to work.Any suggestions please??Thanks

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

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