Hi all,
Below code gives errors
The Standard Inspection DAW Qry - Combined is a union query
Could this be the reason for the error?
Below code gives errors
The Standard Inspection DAW Qry - Combined is a union query
Could this be the reason for the error?
UPDATE DISTINCTROW ([Standard Inspection DAW Qry - Combined] INNER JOIN ((Operations INNER JOIN Control ON Operations.Control = Control.[Control Description]) INNER JOIN [DAW Sheet Temp File] ON Operations.Operation = [DAW Sheet Temp File].Operation) ON [Standard Inspection DAW Qry - Combined].[Standard Inspection] = [DAW Sheet Temp File].[Standard Inspection]) INNER JOIN [Aircraft List] ON ([Standard Inspection DAW Qry - Combined].Type = [Aircraft List].Airframe) AND ([Standard Inspection DAW Qry - Combined].Series = [Aircraft List].Series) SET [DAW Sheet Temp File].[Defect / Additional Work] = [DAW Sheet Temp File]![Standard Inspection] & Chr(13) & Chr(10) & [Standard Inspection DAW Qry - Combined]![Description], [DAW Sheet Temp File].[Mechanical Mhrs] = [Standard Inspection DAW Qry - Combined]![Hours], [DAW Sheet Temp File].[External Service Required] = [Control]![Control], [DAW Sheet Temp File].[Recommended Vendor] = [Operations]![Vendor]
WHERE ((([Aircraft List].[Aircraft Registration])=[Forms]![DAW Sheet - Main]![Registration]));