Private Sub Form_Load() Dim nCount As Long Dim oConn As Object Set oConn = CreateObject("ADODB.Connection") oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\a.mdb" With oConn.execute("SELECT COUNT(0) FROM (SELECT DISTINCT COD_ETAB FROM CandNeuf)") nCount = .Fields(0) .Close End With oConn.Close MsgBox nCount & " valeurs distinctes" End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question