I have a query below in my access
UPDATE invoice SET invoice.[nett profit] = (select [amount]-[supplier cost] from invoice as profit);
when I execute this query it return me with error " operation must use an updateable query"
anyone know this ? and how to fix this error