---not's PIVOT
Select
view_lab_statistic_Order_List.[HN]
,view_lab_statistic_Order_List.[FULLNAME] as Name
,[REQ ITEM NAME] as Test
,Count(LN) as Count
From view_lab_statistic_Order_List
 join view_lab_information_Request_Items_Specimen on view_lab_information_Request_Items_Specimen.[IREQI_LN] = view_lab_statistic_Order_List.[LN]
  and view_lab_information_Request_Items_Specimen.IREQI_CODE = view_lab_statistic_Order_List.[REQ ITEM CODE]
Where ([order inactive]<>'Y') 
and ([req item state]<> 'R') 
and ([TEST INACTIVE]<> '1') 
and ([REQ ITEM ORDER DATETIME] is not null)
and ([REQ ITEM ORDER STAFF CODE] is not null)
and [ISP_STATE] = 'C'

/*
[WARD CODE]
TEST:[REQ ITEM CODE]
[YEAR]
[SEX]
[REQ ITEM ORDER DATETIME]
Order DateTime
GROUP BY: [HN], [FULLNAME], [REQ ITEM NAME]
Having :count(LN) >= 1
not order by
*/