SELECT
UCase(Location.name) AS PRACTICE,
UCase(Staff.firstName) & " " & UCase(Staff.lastName) AS PHYSICIAN,
Sum(IIf(Panel.name Like "CF*",1,0)) AS CF,
Sum(IIf(Panel.name Like "CTNG*",1,0)) AS CTNG,
Sum(IIf(Panel.name Like "GBS*",1,0)) AS GBS,
MonthName(Month(CVDate(DateAdd("s",(Specimen.date/1000),'01/01/1970')))) AS MONTH,
Year(CVDate(DateAdd("s",(Specimen.date/1000),'01/01/1970'))) AS YEAR
FROM
(((Requisition INNER JOIN Location ON Requisition.orderingLocationKey = Location.locationKey)
INNER JOIN Staff ON Requisition.orderingPhysicianKey = Staff.staffKey)
INNER JOIN (Panel INNER JOIN OrderedPanel ON Panel.panelKey = OrderedPanel.panelKey) ON Requisition.requisitionKey = OrderedPanel.requisitionKey)
INNER JOIN Specimen ON OrderedPanel.specimenKey = Specimen.specimenKey
WHERE
((Panel.name) Like "CF*" Or (Panel.name) Like "CTNG*" Or (Panel.name) Like "GBS*")) AND (((Year(CVDate(DateAdd("s",(Specimen.date/1000),'01/01/1970'))))=2007))
GROUP BY
UCase(Location.name),
UCase(Staff.firstName) & " " & UCase(Staff.lastName),
MonthName(Month(CVDate(DateAdd("s",(Specimen.date/1000),'01/01/1970')))),
Year(CVDate(DateAdd("s",(Specimen.date/1000),'01/01/1970')));