|Subject:||Re: Calculating from a summary field?
|Date:||12 Jan 2022 18:40:58 -0400
|From:||"Kevin Zawicki" <email@example.com>
you might do that in sql but with a subquery but in QBE
I think you need two queries
Check.db | Pay_Date | Gross |
| >9/30/2021, <1/1/2022 | Calc sum as "GrossTotal" |
You would need to checkmark a key field unless you wanted the whole table.
the query answer table
ANSWER.db | GrossTotal |
| _G, calc _G * .124 as "GrossTotal124" |
Something like that.
Kirk Dickinson <firstname.lastname@example.org> 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
>Check.db | Pay_Date | Gross | Adv
> | >9/30/2021, <1/1/2022 | Calc sum as Total, _Total | Calc
>Check.db | Fed |
> | Calc sum |
>This email has been checked for viruses by Avast antivirus software.