36Youarecreatingareportwizardtocreateamatrixreport.Thequerybuild,youselectthepatient_namecolumnfromthepatienttable;thedoctor_namefromthedoctorstable;andthedoctor_ID,patient_IDandIDcolumnsfromtheproceduretable.Inthereportwizardyouselectpatient_nameastherow

题目

36Youarecreatingareportwizardtocreateamatrixreport.Thequerybuild,youselectthepatient_namecolumnfromthepatienttable;thedoctor_namefromthedoctorstable;andthedoctor_ID,patient_IDandIDcolumnsfromtheproceduretable.Inthereportwizardyouselectpatient_nameastherowvalue,doctor_IDasthecolumnvaluesandthecountasthecellvalues.Youneedtoaddatotalforeachdoctorscolumn.Inthewizardreportwhichtabwillallowyoutocreatethesummarycolumn?()


相似考题