ник: debilder
Помогите!!! Не работает запрос:
'CurrentDb.Execute ("UPDATE 'C:\ZAKACHKA_EMI\EXPORT\VAT\DATA_NAK177.MDB'.CORP_OU1 INNER JOIN help_corp_ou1 ON (help_corp_ou1.ZVIT_GOD = CORP_OU1.ZVIT_GOD) AND (help_corp_ou1.E_EDRPOU = CORP_OU1.E_EDRPOU) SET CORP_OU1.OUP_Q29S = [help_CORP_OU1].[OUP_Q29S], CORP_OU1.OUP_Q29P = [help_CORP_OU1].[OUP_Q29P], CORP_OU1.OUP_Q29F = [help_CORP_OU1].[OUP_Q29F], CORP_OU1.OUP_Q29G = [help_CORP_OU1].[OUP_Q29G], CORP_OU1.OUP_Q29O = [help_CORP_OU1].[OUP_Q29O], CORP_OU1.OUP_Q29H = [help_CORP_OU1].[OUP_Q29H], CORP_OU1.OUP_Q29R = [help_CORP_OU1].[OUP_Q29R], CORP_OU1.OUP_Q29K = [help_CORP_OU1].[OUP_Q29K], CORP_OU1.OUP_Q29V = [help_CORP_OU1].[OUP_Q29V], CORP_OU1.OUP_Q29T = [help_CORP_OU1].[OUP_Q29T], CORP_OU1.OUP_Q29M = [help_CORP_OU1].[OUP_Q29M], CORP_OU1.OUP_Q29A = [help_CORP_OU1].[OUP_Q29A]," _
'& "CORP_OU1.OUP_Q29D = [help_CORP_OU1].[OUP_Q29D], CORP_OU1.OUP_Q29U = [help_CORP_OU1].[OUP_Q29U], CORP_OU1.OUP_Q29Z = [help_CORP_OU1].[OUP_Q29Z], CORP_OU1.OUP_Q30S = [help_CORP_OU1].[OUP_Q30S], CORP_OU1.OUP_Q30P = [help_CORP_OU1].[OUP_Q30P], CORP_OU1.OUP_Q30F =[help_CORP_OU1].[OUP_Q30F] , CORP_OU1.OUP_Q30G = [help_CORP_OU1].[OUP_Q30G], CORP_OU1.OUP_Q30O = [help_CORP_OU1].[OUP_Q30O], CORP_OU1.OUP_Q30H = [help_CORP_OU1].[OUP_Q30H], CORP_OU1.OUP_Q30R = [help_CORP_OU1].[OUP_Q30R], CORP_OU1.OUP_Q30K = [help_CORP_OU1].[OUP_Q30K], CORP_OU1.OUP_Q30V = [help_CORP_OU1].[OUP_Q30V], CORP_OU1.OUP_Q30T = [help_CORP_OU1].[OUP_Q30T], CORP_OU1.OUP_Q30M = [help_CORP_OU1].[OUP_Q30M], CORP_OU1.OUP_Q30A = [help_CORP_OU1].[OUP_Q30A], CORP_OU1.OUP_Q30D = [help_CORP_OU1].[OUP_Q30D]," _
'& "CORP_OU1.OUP_Q30U = [help_CORP_OU1].[OUP_Q30U], CORP_OU1.OUP_Q30Z = [help_CORP_OU1].[OUP_Q30Z], CORP_OU1.OUP_Q31S = [help_CORP_OU1].[OUP_Q31S], CORP_OU1.OUP_Q31P = [help_CORP_OU1].[OUP_Q31P], CORP_OU1.OUP_Q31F = [help_CORP_OU1].[OUP_Q31F],CORP_OU1.OUP_Q31G = [help_CORP_OU1].[OUP_Q31G], CORP_OU1.OUP_Q31O = [help_CORP_OU1].[OUP_Q31O], CORP_OU1.OUP_Q31H = [help_CORP_OU1].[OUP_Q31H], CORP_OU1.OUP_Q31R = [help_CORP_OU1].[OUP_Q31R], CORP_OU1.OUP_Q31K = [help_CORP_OU1].[OUP_Q31K], CORP_OU1.OUP_Q31V = [help_CORP_OU1].[OUP_Q31V] , CORP_OU1.OUP_Q31T = [help_CORP_OU1].[OUP_Q31T], CORP_OU1.OUP_Q31M = [help_CORP_OU1].[OUP_Q31M], CORP_OU1.OUP_Q31A = [help_CORP_OU1].[OUP_Q31A], CORP_OU1.OUP_Q31D = [help_CORP_OU1].[OUP_Q31D], CORP_OU1.OUP_Q31U = [help_CORP_OU1].[OUP_Q31U]," _
'& "CORP_OU1.OUP_Q31Z = [help_CORP_OU1].[OUP_Q31Z], CORP_OU1.OUP_Q32S = [help_CORP_OU1].[OUP_Q32S], CORP_OU1.OUP_Q32P = [help_CORP_OU1].[OUP_Q32P],CORP_OU1.OUP_Q32F = [help_CORP_OU1].[OUP_Q32F], CORP_OU1.OUP_Q32G = [help_CORP_OU1].[OUP_Q32G], CORP_OU1.OUP_Q32O = [help_CORP_OU1].[OUP_Q32O],CORP_OU1.OUP_Q32H = [help_CORP_OU1].[OUP_Q32H], CORP_OU1.OUP_Q32R = [help_CORP_OU1].[OUP_Q32R], CORP_OU1.OUP_Q32K = [help_CORP_OU1].[OUP_Q32K], CORP_OU1.OUP_Q32V = [help_CORP_OU1].[OUP_Q32V],CORP_OU1.OUP_Q32T = [help_CORP_OU1].[OUP_Q32T], CORP_OU1.OUP_Q32M = [help_CORP_OU1].[OUP_Q32M], CORP_OU1.OUP_Q32A = [help_CORP_OU1].[OUP_Q32A], CORP_OU1.OUP_Q32D = [help_CORP_OU1].[OUP_Q32D], CORP_OU1.OUP_Q32U = [help_CORP_OU1].[OUP_Q32U],CORP_OU1.OUP_Q32Z = [help_CORP_OU1].[OUP_Q32Z]," _
'& "CRP_OU1.OUP_Q33 = [help_CORP_OU1].[OOUP_Q33], CORP_OU1.OUP_Q34 = [help_CORP_OU1].[OUP_Q34], CORP_OU1.reg_number = [help_CORP_OU1].[reg_number], CORP_OU1.region = [help_CORP_OU1].[region];" _
'& "WHERE (((help_corp_ou1.E_EDRPOU)=2006));")