I have the following query that I am trying to get a sum of deductions for a PayPeriod and update the CheckStub record with the totals. I am receiving the error: "Operation must use udatable query" when executing the following query. Any help would be much appreciated!
UPDATE CheckStubInfo, qrySumOfDeductions SET CheckStubInfo.Deductions = [qrySumOfDeductions].[SumOfAmount]
WHERE (((CheckStubInfo.PatronNo)=[qrySumOfDeductions].[Payee ID]) AND ((CheckStubInfo.DATE)=[qrySumOfDeductions].[Date]));
UPDATE CheckStubInfo, qrySumOfDeductions SET CheckStubInfo.Deductions = [qrySumOfDeductions].[SumOfAmount]
WHERE (((CheckStubInfo.PatronNo)=[qrySumOfDeductions].[Payee ID]) AND ((CheckStubInfo.DATE)=[qrySumOfDeductions].[Date]));