Hi All,

I have a database which holds general contact information on about 3 million hospital patients.

I want to create a query to show which patients do not have a telephone number recorded against their record. In the results from the query, i want to show the patient number and patient name.

So far i have managed to create a query which shows the patient number, the patient name and their telephone number, should they have one or not.

Hope you can help.

Phil

add

isnull

into the criteria of the phone number