Make Your Microsoft Dynamics Investment Count & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.
Dim strsql As String Dim nCt As Integer Dim nQtr As String Dim rs As DAO.Recordset Set rs = curDB.OpenRecordset("Select * from tblcurrent") for each (i) If rs.Fields("FreezeQ" & (i)) Then End If Do Until X = nQtr For X = i To nQtr For Each X In nQtr curDB.Execute ("DELETE *" & _ " FROM tblSummary" & _ " WHERE Quarter = " & nQtr & ")") curDB.Execute ("INSERT INTO tblSummary" & _ "Select *" & _ " FROM tblSummaryQuartersFrozen" & _ " WHERE Quarter = " & nQtr & ")") Next MoveNext Loop
|Expression in Access Query Field not showing null results||11||41|
|Ms Access locate folder either this or that||2||29|
|MS Access Docmd export to excel do not over write existing file||9||20|
|Specify the table containg the records you want to delete||14||29|