Recent content by doobybug

It is giving me a syntax error at xx = nz(dsum("[A Outlets]","CityMarket","CityMarket.BranchId)=" & [Forms]![RegBranch]![RegBranch1].[Form].[BranchId]"),0)

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 &...

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...