Search results

  1. J

    DoCmd.RunSQL to update record calculating values from that record

    Below is a line of code that trying to use... DoCmd.RunSQL "Update [Deal Record] SET [Seller - Balance Paid]=" & ((([Seller - Invoice Amount] + [Seller - Swiss VAT]) / InvoiceAmountAfterVAT) * (Me.AlreadyPaid + Me.PaymentAmount)) & " WHERE [Seller - Invoice Reference]='" & Me.InvoiceNumber &...
Back
Top Bottom