Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat. The purpose of this eBook is to educate the reader about ransomware attacks.
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Access module into a teradata procedure or db2 procedure||18||83|
|Create two calculated fields in a table based on one field entered||4||39|
|Mysql query I need to join two tables to get data to build a string and it won't run properly||9||35|
|Using VBA and form selections to append an Access Table - And error 3134||4||13|
Join the community of 500,000 technology professionals and ask your questions.