I have a tricky query that I am trying to perform and I just can't get my head around it. I have a library database with a dateborrowed and duedatereturned field. What I am trying to do is a query which on the date queried will return all records for the books which are currently borrowed.
I had thought about another field which would show status whilst borrowed, which would be fine for current day queries, but I want this to be able to be queried at any given time.
I am sorry, but I am not explaining myself very well.