I have a Doctor#1 treating Patient#1 in 3 different cases and in the report I just need to see 1 instead of 3 as it is the same patient#1 to the same doctor#1. What are the ways I can manipulate this data without writing any program.
Report shows as follows: records
doctor 1 disease 1 patient 1 1
disease 2 patient 1 1
disease 3 patient 1 1
Any help i.e can I write conditions? Selections? or any idea would be greatly appreciated.