G
Guest
I am trying to update the BalanceAmt for an AcctNo in a BalanceForward table
with the results of a NewBalance query. I get the error: “Operation must
use an updateable queryâ€. I have been unable to figure out what to do to fix
this.
The BalanceForward table contains AcctNo, BalanceAmt, and LastInvoiceDate.
The NewBalance query contains AcctNo, BalanceAmt, and NewBal (where NewBal
is itself the result of a query that only uses INNER JOINs).
The query below is what Access generates:
UPDATE BalanceForward INNER JOIN NewBalance ON BalanceForward.AcctNo =
NewBalance.AcctNo SET BalanceForward.BalanceAmt = NewBalance.NewBal;
Can you help please??
with the results of a NewBalance query. I get the error: “Operation must
use an updateable queryâ€. I have been unable to figure out what to do to fix
this.
The BalanceForward table contains AcctNo, BalanceAmt, and LastInvoiceDate.
The NewBalance query contains AcctNo, BalanceAmt, and NewBal (where NewBal
is itself the result of a query that only uses INNER JOINs).
The query below is what Access generates:
UPDATE BalanceForward INNER JOIN NewBalance ON BalanceForward.AcctNo =
NewBalance.AcctNo SET BalanceForward.BalanceAmt = NewBalance.NewBal;
Can you help please??