Sum values based on like criteria

M

Mark Haley

Looking for some basic help on building a query

My goal is to combine like items ("Description" field) from a table and sum
the "TakeoffQty" and the "GrandTotal" then divide the "GrandTotal" by the
"TakeoffQty" and update that data in "TotalUnitPrice"

Now I have some items that do not have duplicates and the exact duplication
is also based on another field in a linked table, field "MinorSection" linked
via "MinorSecCode"
 
Top