|
|
|
|
|
|
|
|
|
|
NewCrop
by Shrinkrap - 02/06/2026 5:56 PM
|
|
|
|
|
|
|
|
|
Posts: 1,023
Joined: February 2011
|
|
#70983
03/22/2017 12:51 PM
|
Joined: Nov 2005
Posts: 2,367 Likes: 2
Member
|
OP
Member
Joined: Nov 2005
Posts: 2,367 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,210 Likes: 8
Member
|
|
Member
Joined: Dec 2009
Posts: 1,210 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 (),
154
guests, and
33
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|
|
|
.png "ACUF Donor I")