Here is the SQL statement:
Code:
SELECT tblBorrowedBooks.DateBorrowed, DateAdd("d",21,[DateBorrowed]) AS DueDate, tblBorrowedBooks.DateReturned, Date()-[DateBorrowed]-21 AS DaysLate, [CallNumberNum] & " " & [CallNumberText] AS CallNumberFinal, tblBooks.BookTitle, [FirstName] & " " & [FathersName] & " " & [FamilyName] AS [Member Name], concatrelated("PhoneNumber","QryPhoneFaxTypes","fkMemberId=" & [pkMemberId]) AS PhoneNumbers, tblBorrowedBooks.pkBorowerId
FROM tblBooks INNER JOIN (tblMembers INNER JOIN tblBorrowedBooks ON tblMembers.pkMemberId = tblBorrowedBooks.fkMemberId) ON tblBooks.pkBookId = tblBorrowedBooks.fkBookId
WHERE (((DateAdd("d",21,[DateBorrowed])) Between [Forms]![frmOverDueBooksDialogue]![txtStartDate] And [Forms]![frmOverDueBooksDialogue]![txtEndDate]) AND ((tblBorrowedBooks.DateReturned) Is Null) AND ((Date()-[DateBorrowed]-21)>0))
ORDER BY DateAdd("d",21,[DateBorrowed]);