[الطالب]

سلام

كود :

Dim sql As String =
    " SELECT [code]         AS [code],      " &
    "        COUNT([code])  AS [count],     " &
    "        SUM([total])   AS [total1],    " &
    "        SUM(SWITCH(VAL([total])>=" & 100 & " AND VAL([total])<=" & 200 & "," & 500 & ",    " &
    "                   VAL([total])>=" & 201 & " AND VAL([total])<=" & 300 & "," & 700 & ",    " &
    "                   VAL([total])>=" & 301 & " AND VAL([total])<=" & 400 & "," & 1000 & ",   " &
    "                   VAL([total])>=" & 401 & " AND VAL([total])<=" & 500 & "," & 2000 &
    "                ))     AS [total2]     " &
    "                                       " &
    " FROM [Reports]                        " &
    "                                       " &
    " WHERE [status] = 'ok'                 " &
    "                                       " &
    " GROUP BY [code]                       " &
    "                                       " &
    " HAVING (SUM([total]) >= 700 )         " &
    "    AND (COUNT([code]) >= 4 )          "

موفقين