I am creating a library database. I'v made this table called loans. Basically, it records the book and the student who borrowed it and the date borrowed and if it is not returned or not. I am going to make a query based on the loan table. I want to be able to search for books that are overdue, that is to add 14 days to the borrow field and compare it to the current date. For the borrowed field what do i have to put in the critera to make this happen?

Try this:
<Date()-14