Good morning,
I have the following query:
SELECT [Customer Returns].[Return Fixed?], Mid([Company Name],18) AS [Comp Name], IIf([File Name]=[3rdPartyList]![3rdPartyName10],[3rdPartyList]![Customer]," ") AS Originator, [Customer Returns].[Processed Date], [Customer Returns].[Individual Name], [Customer Returns].[Individual ID], [Customer Returns].Amount, [Customer Returns].[Return Code], [Customer Returns].ReturnCodeDesc, [Customer Returns].[Effective Date], [Effective Date]+6 AS [Date Due], [Customer Returns].SEC, [Customer Returns].[Correction or Notes], [Customer Returns].Comments, [Customer Returns].DRorCR, *
FROM [Customer Returns] LEFT JOIN 3rdPartyList ON [Customer Returns].[File Name] = [3rdPartyList].[3rdPartyName10]
WHERE ((([Customer Returns].[Return Fixed?])=False))
ORDER BY Mid([Company Name],18), [Customer Returns].[Processed Date], [Customer Returns].[Company Name];
The query doesn't allow me to update the [Return Fixed?] field which is required when complete; I'd appreciate any help with this.
Thanks so much in advance!
I have the following query:
SELECT [Customer Returns].[Return Fixed?], Mid([Company Name],18) AS [Comp Name], IIf([File Name]=[3rdPartyList]![3rdPartyName10],[3rdPartyList]![Customer]," ") AS Originator, [Customer Returns].[Processed Date], [Customer Returns].[Individual Name], [Customer Returns].[Individual ID], [Customer Returns].Amount, [Customer Returns].[Return Code], [Customer Returns].ReturnCodeDesc, [Customer Returns].[Effective Date], [Effective Date]+6 AS [Date Due], [Customer Returns].SEC, [Customer Returns].[Correction or Notes], [Customer Returns].Comments, [Customer Returns].DRorCR, *
FROM [Customer Returns] LEFT JOIN 3rdPartyList ON [Customer Returns].[File Name] = [3rdPartyList].[3rdPartyName10]
WHERE ((([Customer Returns].[Return Fixed?])=False))
ORDER BY Mid([Company Name],18), [Customer Returns].[Processed Date], [Customer Returns].[Company Name];
The query doesn't allow me to update the [Return Fixed?] field which is required when complete; I'd appreciate any help with this.
Thanks so much in advance!