i left these unused elements out - the main benefit of the code was the part

from inserted i, table1 a where i.keyid = a.keyid

that was the eye-opener

works great - thank you!

Hi Frank,

thank you for explaining this to me! At least I will feel better when typing repetitive strings!

Hi Frank,

Thank you for your answer.

The last lines that you suggested would do the same, but it would be inconvenient if I need to reuse "ExecCharge" in 3 or 4 different calculations....

Thanks Noel, option 2 works really well for me. Cheers.