After we print an order I move that record to a History Table.  I do some
calculations and input an amout into a field called [OrderTotal]  It appears
that this works (most of the time) but I have some records where the
[OrderTotal] is incorrect.

The history table has fields [WeightChg], [SpecialChg], and [OrderTotal]

I have a related table OrderExtraCharges that contains multiple records that
must be calculated into the [OrderTotal] in the history table.  The field in
this table is called [ResultsChg]

I have created a query that calculates the [NewTotal] that is working
properly
[WeightChg]+[SpecialChg]+[SumOfResultsChg]

I want to go thru each record in the history table and update [OrderTotal]
to the value in my query called [NewTotal].

I know this is probably very easy, but I have been working on it for two
days, and am still not getting it.

Any help would be appreciated.

Thanks in advance

Replace the table names with the correct names, and replace
PrimaryKeyField with the name of the appropriate primary key field.

--
Hope this helps
Tony Oakley (MVP)