DBlank;
With our combined power, we could rule the world. Well, maybe you could. I'm still learning.
Okay, Ran the Report and it still gave me "five" instead of "four" results.
Rechecked Formula, and I had forgotten to add the second Client.med_rec_no (MRN) for the Count range. (sigh)
Ran the Report again and it gave me a result of "one" which indicates to me the Count evaluation was correct, but I needed to know how many Primary singular records there were, not >1. It did give the correct number of records that had more than one MRN.
By changed the operation from ">" to "=", the result now reads as "four."
Just to double check, I increased the range to include 11/25 - 11/30, results should equal ten, and IT DOES!
Thank you. I think I found an AWESOME forum.
- JDart
IP Logged
