Search results
-
M
How to loop an update query on all records of a table
hi every body, finally I did and correct the code myself and this is my final code which has been tested: Dim rs As DAO.Recordset Dim strSQL As String Set dbs = CurrentDb() Set rs = dbs.OpenRecordset("Table1", dbOpenTable) strSQL = "UPDATE Table1 SET Table1.[Total Accounts] = [Account];"...- macut
- Post #4
- Forum: Modules & VBA
-
M
How to loop an update query on all records of a table
hi everybody... I've set a database which has a table in which there are 2 fields "Account" and "Total Accounts". I want to have the amount of total summation of accounts in "Total Accounts" field of each record, which is the result of summation of "Account" values in all previous records till...- macut
- Thread
- Replies: 3
- Forum: Modules & VBA