I believe you should have three tables: Physicians, Patients and Scans. If you connect them in a parent -< child -< grandchild pattern, you should have no problem counting the scans of each physician in a calculation field =
Count ( Scans::ScanID )
I am not sure what you mean by "running" total here.
Thank you for the quick reply. I took your advice... sort of. By blindly trying different things I was able get what I needed. I was definitely making it a harder problem than it really was. On your advice I just simplified a few table relationships and presto! My next endeavor will no doubt lead me back to this forum. I hope you're around to help again.