|
|
|
Posts: 12,908
Joined: September 2003
|
|
#70983
03/22/2017 1:51 PM
|
Joined: Nov 2005
Posts: 2,370 Likes: 2
Member
|
OP
Member
Joined: Nov 2005
Posts: 2,370 Likes: 2 |
I am working on PCMH and trying to run a report for patients without a telephone number seen in the last 3 months.
the problem is that the report will not allow = or <> (blank), it requires 10 digits ( % wildcard will not work).
Any ideas?
Wendell
Pediatrician in Chicago
The patient's expectation is that you have all the answers, sometimes they just don't like the answer you have for them
|
|
|
|
|
Joined: Dec 2009
Posts: 1,211 Likes: 8
Member
|
|
Member
Joined: Dec 2009
Posts: 1,211 Likes: 8 |
Just add a WHERE clause to the query I put in a previous post. Change dates as appropriate. DECLARE @StartDate DATETIME
DECLARE @EndDate DATETIME
SET @StartDate = '1/1/2017'
SET @EndDate = '4/1/2017'
SELECT Demographics.PatientID, [Last] as LastName, [First] as FirstName, Gender, BirthDate, Phone FROM Demographics INNER JOIN
(SELECT DISTINCT PatientID FROM Billing WHERE DateOfService BETWEEN @StartDate AND @EndDate) as a on Demographics.PatientID = a.PatientID
WHERE phone is null or phone = ''
ORDER BY LastName
JamesNT
|
|
|
|
0 members (),
316
guests, and
70
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|
|
|
.png "ACUF Donor I")