14-09-15, 12:00 AM
سلام
موفقين
كود :
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 ) "موفقين
متغيب
