Originally Posted by
BDibz
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
Code:
ElectrodeQty: Sum(([Qty In]-[Qty Out]))
Code:
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
Code:
ElectrodeQty: Sum([Qty In]-[Qty Out])
Rewrite the second expression replacing ElectrodeQty with the expression used to calculate it
Code:
ElectrodesNeeded: Round(([partQty]/[partsPerElectrode])-Sum([Qty In]-[Qty Out]))
Alternatively, do one query to calculate ElectrodeQty then another query to get ElectrodesNeeded