L
lisae
Hi - I think this may have already been answered, but I'm having a hard time
with applying the solution to my problem.
I'm running a query from a linked database where I'm getting the count of
exams done by doctors. The list is appearing as follows:
Exam Desc Dr1 Dr2 Dr3 Dr4
exam1 3
exam1 6
exam1 12
exam2 3
exam2 3
But I would like it to appear as follows:
Exam desc Dr1 Dr2 Dr3 Dr4
exam1 3 6 12
exam2 3 3
What do I need to do?
Thankyou in advance.
with applying the solution to my problem.
I'm running a query from a linked database where I'm getting the count of
exams done by doctors. The list is appearing as follows:
Exam Desc Dr1 Dr2 Dr3 Dr4
exam1 3
exam1 6
exam1 12
exam2 3
exam2 3
But I would like it to appear as follows:
Exam desc Dr1 Dr2 Dr3 Dr4
exam1 3 6 12
exam2 3 3
What do I need to do?
Thankyou in advance.