Search results
-
D
Update table from results of a query
It is giving me a syntax error at xx = nz(dsum("[A Outlets]","CityMarket","CityMarket.BranchId)=" & [Forms]![RegBranch]![RegBranch1].[Form].[BranchId]"),0)- doobybug
- Post #3
- Forum: Modules & VBA
-
D
Update table from results of a query
Hi, I have a table Branches and I want to update it with the result of a query. Is it possible? Here is what I've done: Private Sub GetData_Click() Dim SQL As String SQL = "UPDATE Branches " & _ "SET Branches.[A Outlets] = d.[SumOfA]" & _ "Where (((Branches.[BranchId]) = " & Me.Text86 &...- doobybug
- Thread
- Replies: 3
- Forum: Modules & VBA
-
D
Update Record from a form using a button
Hi, I am very new to this so any help will be very much appreciated. I have 2 tables: Branches BranchId (PK) Name Population A B C CityMarket CityMarketId (PK) BranchId (FK) A B C This is to get the relation that a branch can have various CityMarkets. Now I have a form for Branches...