算Grether而不是值 [英] Count Grether than Values

问题描述

大家好



如何计算Gretherthan 35我需要数量并显示给DGV



在这里我使用CODE代码

Hi All

How to Count Gretherthan 35 more i need Count and display to DGV

Here i USE CODE FOR COUNT

If DGV1.Rows(CC_tot).Cells(4).Value = Dset9.Rows(jj).Item("Paper1") And Dset7.Rows(j2).Item("Paper1") >= 35 Then
                       Dim vCC, vTC As Integer
                       vCC = Dset7.Rows(j2).Item("Paper1")
                       vTC = vCC
                       MessageBox.Show(vTC)
                       DGV1.Rows(CC_tot).Cells("PassStudent").Value = Dset7.Compute("COUNT(Paper1)", "") endif

请告诉我如何计算数据库值> 35

Please Tell me How to count Database Value >35

推荐答案

DGV1.Rows(j1).Cells("PassStudent").Value = Dset7.Compute("Count(Paper1)", "Paper1 >= 35")

计算数据库值，使用查询作为DGV数据源：

To count database values, use query as DGV datasource:

SELECT PassStudent, COUNT(Paper1) AS CountOfPaper1 
FROM YourTable
GROUP BY PassStudent
ORDER BY PassStudent

这篇关于算Grether而不是值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！