K
Kurt42
I am trying to do a report that will show the number of items remaining in
inventory on a monthly basis. Fields would be like numunits, unitsold,
remaining.
I assume I would need a variable to store June’s remaining total (or
previous month) in order to calculate July’s remaining total by subtracting
the number of items sold in July from June’s remaining total and so on for
the remaining months. Obviously the initial months remaining total would be
calculated by (numunits – unnitsold )= remaining
Can anybody supply a sample of code that I could use to make this work?
inventory on a monthly basis. Fields would be like numunits, unitsold,
remaining.
I assume I would need a variable to store June’s remaining total (or
previous month) in order to calculate July’s remaining total by subtracting
the number of items sold in July from June’s remaining total and so on for
the remaining months. Obviously the initial months remaining total would be
calculated by (numunits – unnitsold )= remaining
Can anybody supply a sample of code that I could use to make this work?