N
Nick hfrupn
I am trying to write a report where records are selected for pieces of
equipment. In a linked table I record the date and amount of oil added to
each piece of equipment. If the oil is completely changed out I record the
date of the oil change, the amount of oil added and tick a check box to
indicate that the oil was changed.
I have a report that shows the details for each piece of equipment. I need
to add a sub report to sum the oil added from the last time the oil was
changed, not including the changed amount.
How do I Sum the oil added after the last oil charge, not including the
quantity of oil used in the change?
The fields in if linked table are:
Equip ID, (number) OilAdded, (number) OilChanged, (Checkbox)
All help is appreciated
Nick
equipment. In a linked table I record the date and amount of oil added to
each piece of equipment. If the oil is completely changed out I record the
date of the oil change, the amount of oil added and tick a check box to
indicate that the oil was changed.
I have a report that shows the details for each piece of equipment. I need
to add a sub report to sum the oil added from the last time the oil was
changed, not including the changed amount.
How do I Sum the oil added after the last oil charge, not including the
quantity of oil used in the change?
The fields in if linked table are:
Equip ID, (number) OilAdded, (number) OilChanged, (Checkbox)
All help is appreciated
Nick