Help Needed to Create Query to eliminate Is Null Records

Folks,

I have a table called "Radio_Issued" with three fields "Radio_ID", "Issue_Date" and "Return_Date". Now I want to create a Query to show only the records WHERE "Return_Date" Is Not Null.

Purpose of this Query to list out how many Radios in hand and how many Radios issued.

I tried to create a Query by setting the criteria “Is Not Null” in “Return_Date” field, but Failed, since some “Radio_ID” have both records (Is Null and Is Not Null) in “Return_Date” field.


I have attached the Database and picture of what I am trying to accomplish.




Thanks in advance,

Joshi

Hi Chance,

Thank you so much for your swift response and help. But I am new in Access, can you please tell me what is subquery and where I have to put this criteria. Sorry I am beginner in Access.

Thanks,
Joshi

Hi Chance2,

Thank you so much...its working perfectly. Much much appreciated!

Joshi