Don't ignore that you may have a database design issue. If every time you get a new physician you have to add a column to each record, you have a problem. Better would be a relational structure in which you have a table of physicians with a code for each. Then a table of patients with a code for each. Lastly, a table of interactions in which each record is an interaction containing a physician code, a patient code, a date, and whatever else might be needed. Makes counting interactions by patient, interactions by physician, or interactions by date or type much easier.
... View more