I want to be able to calc a sum from a Gross field and then multiply 
that for a new field. I can't for the life of me figure it out and I 
can't seem to find much on the Net about QBE anymore.

I have tried this, but the result is not from the sum

Query
ANSWER: :PRIV:ANSWER.DB

Check.db | Pay_Date              | Gross                     | Adv 
        |
          | >9/30/2021, <1/1/2022 | Calc sum as Total, _Total | Calc 
_Total*.124 |

Check.db | Fed      |
          | Calc sum |

EndQuery

-- 
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus