| Selected Rows [message #377725] |
Wed, 24 December 2008 11:53  |
jfrano
Messages: 11
Registered: January 2007
Location: New York
|
Junior Member |
|
|
I've written a report that returns values of a test when the results are >300. However, I'm having difficulty, with the user request to only show, those patients that have had 3 or more results (>300), within a week.
# Name, MRN, Event Date, Test Result
1 JoeD 145 1-jan-2008 00:15 325
2 JoeD 145 2-jan-2008 11:59 344
3 JoeD 145 15-Jan-2008 05:22 355
4 JohnR 332 1-Feb-2008 19:22 344
5 JohnR 332 9-apr-2008 10:59 422
6 JohnR 332 10-Apr-2008 11:22 322
7 JohnR 332 10-Apr-2008 15:29 344
8 JohnR 332 11-Apr-2008 18:22 443
9 JohnR 332 17-Apr-2008 18.21 387
So in this case I would want to see row #5,6,7,8
Any suggestions to achieve this??
Thanks
[Updated on: Wed, 24 December 2008 12:03] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
