trying to display library books that are currently on loan

[babydave]

i have a library system.

Id like to make a query that displays all the books that are out on loan, i have a date returned column so if this is null then id like all the books with a null value to be displayed? just cant get it to work?

also is there any way to send out a mail merge letter if a book is overdue?

thanks in advance

 

[sfreeman@co.mer]

SELECT
tblBooks.*

FROM tblBooks

WHERE
(((tblBooks.ReturnDate) Is Null));

As for the letter, if the users all have e-mail, take a look at the SendObject action in the Help file.

You can create a recordset consisting of all overdue books, and loop thru that recordset sending a 'canned' e-mail to each.