Why is query asking for an input parameter that is redundant

[BDibz]

I am trying to do an inventory system, where the current inventory is calculated by a sum of in/out transactions for that part as "ElectrodeQty", and then based on the job forecast for the next month, the gap between current inventory and inventory needed is calculated with "ElectrodesNeeded". Right now, the query does work; however, it asks for an input parameter "ElectrodeQty" even though that is a variable present in the query itself. Any ideas why this may be?

ElectrodeQty: Sum(([Qty In]-[Qty Out]))

ElectrodesNeeded: Round(([partQty]/[partsPerElectrode])-[ElectrodeQty])

[orange]

Could be you have to do the Sum of transactions first.

[isladogs]

Your expression uses ElectrodeQty which is a calculated field from the query - therefore it needs to reference the query parameter [Forecast Month]
But that parameter is incorrect as the field name has no space.
Its also unnecessary - you are grouping by that field - remove the parameter
Are you sure you need to group by that field at all as you aren't showing it

[BDibz]

Your expression uses ElectrodeQty which is a calculated field from the query - therefore it needs to reference the query parameter [Forecast Month]
But that parameter is incorrect as the field name has no space.
Its also unnecessary - you are grouping by that field - remove the parameter
Are you sure you need to group by that field at all as you aren't showing it

I don't quite understand. I'm using Forecast Month field to select a month from the Jobs table so that it only displays results from that month. What it says in brackets is just what the user input box prompts for, then it looks up that month in the Jobs table and returns those. How is this related to ElectrodeQty?

[isladogs]

I don't quite understand. I'm using Forecast Month field to select a month from the Jobs table so that it only displays results from that month. What it says in brackets is just what the user input box prompts for, then it looks up that month in the Jobs table and returns those. How is this related to ElectrodeQty?

Sorry - my previous reply was nonsense - ignore what I wrote before

You have 2 expressions - one dependent on the other

ElectrodeQty: Sum(([Qty In]-[Qty Out]))

ElectrodesNeeded: Round(([partQty]/[partsPerElectrode])-[ElectrodeQty])

Access can't do the second expression as the value for the first part hasn't been set

The first has too many brackets though it will work. This is better

ElectrodeQty: Sum([Qty In]-[Qty Out])

Rewrite the second expression replacing ElectrodeQty with the expression used to calculate it

ElectrodesNeeded: Round(([partQty]/[partsPerElectrode])-Sum([Qty In]-[Qty Out]))

Alternatively, do one query to calculate ElectrodeQty then another query to get ElectrodesNeeded

[BDibz]

Thank you, that makes much more sense. I assumed it would calculate values sequentially and store them before calculating the next.