Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
Dim rs As New ADODB.Recordset rs.Open "SELECT PO.PO_ID, PO.ChargedTo, CCur(Sum([unitprice]*[quantity])) AS SubTotal, CStr([FileNumber] & [Unit]) AS JobNum " & _ "FROM sysTempPO as PO INNER JOIN sysTempPO_Details as POD ON PO.PO_ID = POD.PO_ID " & _ "GROUP BY PO.PO_ID, PO.ChargedTo, [FileNumber] & [Unit];", CurrentProject.Connection, adOpenStatic For i = startOfUsed To endOfUsed If wks.Cells(i, startColumn) = "" And Left(wks.Cells(i, wks.Range("_JOBNUM").Column), 2) = "16" Then rs.MoveFirst rs.Find "SubTotal = " & CCur(wks.Cells(i, totalsColumn)) & " AND JobNum = '" & CStr(wks.Cells(i, wks.Range("_JOBNUM").Column)) & "'", 0, adSearchForward, 0
|MS Access How to Import Text Document such as CSV File into Table and get Access to Accept a Short Text For a Autonumber Field||15||40|
|MS Access Search and Replace Using VBA||6||29|
|Confirm a record has been added MS Access||4||17|
|VBA/SQL - Connect to SQL server and pull data||4||40|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!