Tracking the Source

[Tuckejam]

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

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]

I was never great at reports but I get that the ACMQuantityRecived is part of the main control source qryACMProjectInventorySummary_Report

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

[Tuckejam]

i had a follow up but deleted it because i figured it out.

still need help with the original post

[June7]

Advise not to use spaces in naming convention. Advise not to use alias names same as field names.

Why do field names in the last expression not match alias names you show in list?

[Tuckejam]

Advise not to use spaces in naming convention. Advise not to use alias names same as field names.

Why do field names in the last expression not match alias names you show in list?

Oh there are so many things I would have done differently if I was the Architect. To Start I would not have used MS Access to build an ERP system to run a multi-million dollar company.
but given the size of this thing its to late to go back and change it. Im just trying to unwind the inventory reports, try to get that migrated over to a real MRP and then go from there.


my mistake on not keeping the names correct in what i listed on the left side of the ordinal post. that is the name on the printed report for those fields. and i was pulling that off a spreadsheet i have helping me keep track of everything, I should have put more thought into it before I posted that would be confusing.

[mike60smart]

Hi

This Field on the Report :-

Transferred: =Nz([QuantityAdjustment],0) This just means if the field QuantityAdjustment in the underlying Query is Null, display a Zero

[Tuckejam]

Got it!

I had assumed that was something to that effect, but wanted to be sure. impossible to build anything with faulty logic.

thanks