Access: Create a query that displays movies loaned out in Access 2003/XP/2000/97

Question:  I have created an Access 2003/XP/2000/97 database for my movie collection. I have a table called Movies whose fields are Movie Title, Loaned To, and Date Loaned.

I'd like to create a query that displays only the movies that are loaned out.

How can I do this?

Answer:  To create a report that displays all movies that are loaned out, you need to return all records from the Movies table where there is a value in the [Loaned To] field. You can do this with the query below:

This query would return all records where the [Loaned To] field is not null. In other words, only those movies that have been loaned out.