Ok went with create a table to hold the Sum and the Rate, then append them along with the calculation back into the Invoice Data Table.
I tried it before but was trying to do it in one query. I guess it could not Sum then use that for a second calculation in the same Query.
Thanks All...