Can't update query

[radek225]

Why below query is not updatable?

sql = "Update Tbl_Raport_hd_sumyTys " & _
    "set tbl_raport_hd_Sumytys.SI_MAxxx = (select sum([Tbl_Raport_hd_iloczynyJedn].[I_MAxxx]) from Tbl_Raport_hd_iloczynyJedn where [Tbl_Raport_hd_iloczynyJedn].[nr_wyc] = [Tbl_Raport_hd_sumyTys].[nr_wyc] and [Tbl_Raport_hd_iloczynyJedn].[gr_Tar] = [Tbl_Raport_hd_sumyTys].[gr_tar] and [Tbl_Raport_hd_iloczynyJedn].[rm] =[Tbl_Raport_hd_sumyTys].[rm] group by [Tbl_Raport_hd_iloczynyJedn].[nr_Wyc], [Tbl_Raport_hd_iloczynyJedn].[gr_Tar], [Tbl_Raport_hd_iloczynyJedn].[rm])"

 

[Ranman256]

Instead of SQL, try running it in a query. It sometimes gives you the error.
BUT, you cannot Sum and update in the same query.
You can write the sums to a temp table, then update from that.