List of Items not borrowed for a specific period!

[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

[pulpfiction]

Try this...SELECT a.Date_Borrowed, a.Title, a.Author FROM v_Catalogue aWHERE (NOT (a.Date_Borrowed BETWEEN 'startdate' AND 'enddate'))