Rlist duplicate rows (AREV Specific)
At 18 JAN 2000 12:02:50PM Deborah Twigg wrote:
I am sorting 27,000 records (patient diagnoses for a 1-year period) to get a total number of patient visits for each diagnosis. Is there a way to supress duplicate rows (some have over 1,000)so that each diagnosis is listed only once, with the total number of times this diagnosis was used? I'd appreciate any time-saving advice. Thanks
At 18 JAN 2000 12:06PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
List Table By Diagnosis Break-On Diagnosis "'V'" Total Count Det-Supp
should do it.
World Leaders in all things RevSoft
At 18 JAN 2000 12:08PM Tony Marler @ Prosolve Software wrote:
Deborah
Play around with GROUP and DET-SUPP.
Tony
At 18 JAN 2000 01:27PM Deborah Twigg wrote:
Hi:
Using List table by diagnosis break-on diagnosis "v" total count det-supp got my report down to one-liners for each diagnosis, but now instead of listing what the diagnosis is, it has everything as "v". How can I now get it to list what the actual text diagnosis should be?
At 18 JAN 2000 01:31PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Why, thanks for that Tony.
Your friends
The Group
World Leaders in all things RevSoft
At 18 JAN 2000 01:33PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
double quote single quote V single quote double quote
World Leaders in all things RevSoft
At 18 JAN 2000 01:37PM Deborah Twigg wrote:
Hi there:
When I use the "'v'" I now get *** instead of a whole list of Vs. Are we getting closer?
At 18 JAN 2000 01:41PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
V not v
World Leaders in all things RevSoft
At 18 JAN 2000 01:44PM Deborah Twigg wrote:
Thanks! I got it now! You've saved me many hours of work.
At 19 JAN 2000 12:39PM Tony Marler @ Prosolve Software wrote:
Andrew (I guess)
Thanks for not mentioning that on my only post in about 2/3 weeks I included a stunning combination of RLIST and SQL all in the same sentance. Not only would it not work but I bet if it did it wouldn't be legal !
Tony
At 19 JAN 2000 12:45PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
- we must have a beer again soon!
[/i]World leaders in all things RevSoft[/i]
