I am new to access and started making a database for a spreadsheet. I am using access 2000. I have a column which displays the total production for a month schuler_month_p rod. One column displays production for each week schuler_complet ions. When I was using excel I could just display the total for a month by a formula which added the production for each week and displayed it in the month section. I wrote a query to do the same. The query is as follows.
I got the error: operation must run an updateable query
Code:
UPDATE weekly_schuler_prod_nrft_tbl SET schuler_month_prod = (SELECT SUM([schuler_completions])
FROM [weekly_schuler_prod_nrft_tbl]
WHERE [week] IN ("40","41","42","43"))
WHERE [week]="43";