Update Query

[tbassngal]

Hi everyone... I've done update queries many times before but am having difficulties with this particular query. I've tried this a number of different ways... and obviously none of them work. Bottom line is that I have a field called POQty I want to keep the actual value of POQty but I also want to add a new field that will sum POQty for all same ProjectID and Pack Item #'s. What I did is create a number of different queries to get the summation, and then I've even tried creating a whole seperate query to do the update (the field name is Tina in this example). I keep getting an error message "Operation must be an updateable query" - I have no idea what to do next.

I've tried:

UPDATE Query1 SET Query1.[Total_ POQTY] = [R_DeliveryStatus]![Tina]
WITH OWNERACCESS OPTION;

I've tried:

UPDATE R_DeliveryStatus LEFT JOIN Query2 ON (R_DeliveryStatus.ProjectID = Query2.ProjectID) AND (R_DeliveryStatus.[Pack Item #] = Query2.[Pack Item #]) SET Query2.[SumOfTotal_ POQTY] = [R_DeliveryStatus]![Tina]
WITH OWNERACCESS OPTION;

All with the same error message.

Please help. Thank you so much for your time! PS: I used the design view to create the query.

Tina K

 

[SkipVought]

Tina K,

It's generally NOT a good idea to put aggregate values in a Table. That's what you do when you report/query.

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[SkipVought]

... that is, unless you're constructing a CUBE.

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}