I need to create a query to see the names of the music currently checked out

**Mahnoor** · 02-08-2019, 11:48 AM

I need to create a query to see the names of the music currently checked out using the date out and date in fields. I don't know how to do that please help me out.

**pbaldy** · 02-08-2019, 11:50 AM

In the criteria for the field that would record the return, put

Is Null

**Mahnoor** · 02-08-2019, 11:54 AM

Thank you so much. It worked

**pbaldy** · 02-08-2019, 12:59 PM

Happy to help and welcome to the site!

I need to create a query to see the names of the music currently checked out

Thread Tools

I need to create a query to see the names of the music currently checked out

Similar Threads

Create Database - Music Singer, Artist. view information and add notes to it

How to sort field names by the result of a query and create a report that contains grouped results ?

Create something that will be useful with mail merge and multiple values checked per record

Create a Report from a form with numorous checkboxes then printing only checked boxes

create a query to find names not entered

Posting Permissions