Update query help

[techexpressinc]

I am trying to update counts in a table. But I can not get the update to run. Attached is a snapshot. Thx for any help. Russ

code -
UPDATE [WeekBill Of Draft Billing query-cnt-families-per-agency2] INNER JOIN [Report-Family-Cnt] ON [WeekBill Of Draft Billing query-cnt-families-per-agency2].Address = [Report-Family-Cnt].Agency SET [Report-Family-Cnt].FamilyCount = [WeekBill Of Draft Billing query-cnt-families-per-agency2.CountOfFAMILY NUMBER-CR]
WHERE ((([Report-Family-Cnt].Agency)=[WeekBill Of Draft Billing query-cnt-families-per-agency2.Address]));

[SoftwareMatters]

What is the problem - why won't it run, any errors??

[techexpressinc]

I have updated the names. To make more sense.

The update query is still failing with the error message: "Operation must use updateable query".

The query that calculates the numbers that goes into the update query runs good.

I have attached a new snapshot.

Russ at Scaninc.org

[SoftwareMatters]

Are the 2 queries that are linked updateable? (to check, open them and make sure the new record icon is not greyed out on the record selectors)
If not then that's why your update query won't run.

[techexpressinc]

I created a separte new table from the query then bring that it.
It overlays table on a re-run of the query.
GREAT advice - I am working without a manual intervention. I build the counts into a table. Thx.
SELECT WeekBillDraftCntFamiliesPart2Qry.Agency, WeekBillDraftCntFamiliesPart2Qry.FamilyCntNumber INTO weekbillfamilycnts
FROM WeekBillDraftCntFamiliesPart2Qry;

weekbillfamilycnts
is the table.

Thx for your
Help
Russ