UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Query to find missing phone numbers    
 
   
NHS
post Aug 1 2005, 01:28 AM
Post #1

UtterAccess Addict
Posts: 287
From: North West, U.K.
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
Go to the top of the page
 
+
dannyseager
post Aug 1 2005, 01:30 AM
Post #2

UtterAccess VIP
Posts: 13,031
From: Leicester, UK
add

isnull

into the criteria of the phone number
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 07:33 AM