I am keeping track of education credits for several doctors. We break them down into categories and not all doctors obtain credits in all categories.
Course ABC
CT - 2.00
MRI - 3.00
Ultrasound - 0.00
Interventional - 0.00
Total Credits - 5.00
I'd like to build a query that displays all credits in all categories that have been populated only, so I don't have a bunch of "0.00"s unneccessarily.
What's the best way to do this?
Course ABC
CT - 2.00
MRI - 3.00
Ultrasound - 0.00
Interventional - 0.00
Total Credits - 5.00
I'd like to build a query that displays all credits in all categories that have been populated only, so I don't have a bunch of "0.00"s unneccessarily.
What's the best way to do this?