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.