sql - Error with addition in MS Access one table to another? -

I have 5 columns and 5 rows in my table, now just add AmountPaid column to me Need 3 rows and other tables that you want to store in the table are unique codes and recording this unique code I want to add this total amount to the new table.

I tried this code, but how not working except me.

  Select No invoice, Invoice-date, Salesperson (Sales Sales from Sales Salespus where Sales Department. Salesperson ID = Invoice. Sales Process) Salesperson, Client, Order Number, Grandot, Amountpaid (Payment Amount Payment of payment from where payment: no explanation = invoice. Invoice non) Evoound invoice;  

If I remove the last column Paid column then this code is working fine. But I have to add the subsidized amount of a table and store it on the second table column. How to complete this task?

Hope it helps.

Subkey:

  Select Invoice, Invoice Date, (Sales Salesperson, Sales Department, where Sales Department. Salesperson ID = Invoice. Sales Process) Salespersons, Clients, Orders Select the payment from the number, grandolate, (payment amount). INvoiceNo) Total total payment by invoice;  

Equation:

  Select No Invoice, Invoice-Date, Sales Transmission, Customer, Order Number, Grandotle, SUM (Rashipped) as Total Total Amount Invoice Sales Dept. from INNER Sales Dept. SalesPersonId = Include payments on Invoice SalesPerson INNER payment. InvoiceNo = Invoice.InvoiceNo Group invoice