updating table using results of another query

[AdrianoG87]

Hi All,

I am trying to update 1 table using the results of a query that performs a sum from another table.

i have a query that performs a sum of freight charges grouping by an invoice number

the result of which is an invoice number and a total freight amount

i have a table with invoice number and amount left blank

once i have finished calculating my freight charges, i need a query that matches the invoice numbers and updates the blank amount field with the calculated amount

and on top of that, i need the update to only run for the invoice number that is present on a form.

i have hit a dead end, i get a "operation must use updateable query" i have no idea what this means either.

any help would be great, no coding though, im a newbie.



thanks all

[pdebaets]

I think updating is a bad idea in this case. I suggest you use a DSum to put the freight charges on the invoice form. Ex.: In your FreightCharges control ControlSource property put

=DSum("MyFreightChargeAmountField", "MyFreightChargesTable", "InvoiceID = " & me!InvoiceID)

(replace field, control and table names as needed)