---

MS Access 2003: Create a query that displays movies loaned out

This MSAccess tutorial explains how to create a query that displays movies loaned out in Access 2003 (with screenshots and step-by-step instructions).

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.