you might do that in sql but with a subquery but in QBE



I think you need two queries

Query
ANSWER: :PRIV:ANSWER.DB

Check.db | Pay_Date              | Gross                    |
         | >9/30/2021, <1/1/2022 | Calc sum as "GrossTotal" |

EndQuery
You would need to checkmark a key field unless you wanted the whole table.

the query answer table

Query
ANSWER: :PRIV:ANSWER.DB

ANSWER.db | GrossTotal                            |
          | _G, calc _G * .124 as "GrossTotal124" |

EndQuery



Something like that.




Kirk Dickinson <kirk@texaslonghorn.com> wrote:
>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
>