I'm trying to dig through company database and figure out what its really doing.
right now im trying to track the source of a couple of numbers on a report.
I have
rptACMProjectInventory and its main control source is qryACMProjectInventorySummary_Report
now the fields in the report and their control source are
I was never great at reports but I get that the ACMQuantityRecived is part of the main control source qryACMProjectInventorySummary_Report
Received ACMQuantityReceived Transferred =Nz([QuantityAdjustment],0) Damaged =Nz([QuantityDamaged],0) Miscut =Nz([QuantityMiscut],0) Overcut =Nz([OverCut],0) Cut =Nz([TotalCutExcludingDrop]-[OverCut],0) To Cut =Nz([TotalRemainingToCut],0) Remaining =[ACMQuantityReceived]+[Quantity_Adjustment]-[Quantity_Damaged]-[Quantity_Miscut]-[Over_cut]-[QuantityCut]-[ToCut]
but the =Nz([QuantityAdjustment],0) I dont get.
do all those still have the main control source just like ACMQuantityRecived does but with the Nullzero function added to it?
and then of course i know that last one is just an expression.
thanks for the help