The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.
SELECT [BIM Software].ID, CountL([id],"L1") AS Total_L1, CountL([id],"L2") AS Total_L2, CountL([id],"L3") AS Total_L3 FROM [BIM Software] GROUP BY [BIM Software].ID; Function CountL(recID, L) Dim rs As DAO.Recordset, db As DAO.Database, cntL As Integer Dim j As Integer Set db = CurrentDb Set rs = db.OpenRecordset("select * from [BIM Software] where iD=" & recID) Do Until rs.EOF For j = 1 To rs.Fields.Count - 1 If rs.Fields(j) = L Then cntL = cntL + 1 End If Next rs.MoveNext Loop rs.Close CountL = cntL End Function
|Microsoft Access Dcount -- check if field has a valid date||5||34|
|MS Access How can I add 2 list boxes to the current bulk insert code in my Access database?||8||8|
|Local HTML file to display local Access MDB data in browser||4||29|
|add criteria to query in VB, Access 2003||2||12|