Help Updating Form Field

[emarchant]

I have a form that users input data into for each PO on an Entry document.



The info would look like this:

Entry# PO# Weight Cost BU BU%
1234 ABC 100 $100 RT
1234 DEF 200 $150 RT
1234 GHI 100 $100 WH

I have a query that ultimately calculates the BU% based on weight. The total weight on the Entry# is in another table. The query successfully calcs the proper percentage.

Here is my problem: I cannot get that percentage into my table/form! I can't use an update query because I have used "Group by" in my queries and keep getting the "Operation Must Use an Updateable Query" error message. I want my data to look like this in the table/form:

Entry# PO# Weight Cost BU BU%
1234 ABC 100 $100 RT 75%
1234 DEF 200 $150 RT 75%
1234 GHI 100 $100 WH 25%

How can I do this??? I am in Access 2007.

Thanks so much for your help!!!!!!!!!

[TheShabz]

save the first part into a temp table and then insert that into your main table.
so have that temp table store the info for that series of data entry (the 3 you have listed). Then INSERT INTO your main table.

INSERT INTO masterTable (Entry#, PO#, Weight, Cost, BU, BU%)
SELECT * FROM tempTable

[emarchant]

I have never created a temp table before... how do I do that?

[weekend00]

If you don't the slow speed, try following:
update tablea set [BU%]= davg("BU", "OtherTable","[entry#]=" & tablea.[entry#])

Note: If [entry#] is not a number, you need to put it inside ''.