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">>>[WARD CODE]
    
 "TEST"     >>>      [REQ ITEM CODE]

    
    
    
    [SEX]
[REQ ITEM ORDER DATETIME]
Order DateTime
    ----start("ว่าง")
     ----END("ว่าง")
[HN], [FULLNAME], [REQ ITEM NAME]
count(LN) >= 1