GSalmson

Tricky Query

Discussion created by GSalmson on Oct 9, 2016
Latest reply on Oct 13, 2016 by beverly

Hello Everyone.

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.

 

Regards

Outcomes