Hi All,
I would also like some help with form filtered differences in totals.
I have a main form for the client, and a continuous subform listing
client transactions. The subform can be filtered by several fields. I
have set up several text boxes which programatically show various
OnCurrent subtotal details depending on the filtered options in the
continuous subform.
I wish to populate one of the form footer subtotal text boxes with the
value of the difference between the highest and lowest amount as
currently shown in the field 'Volume' at any time.
I can produce a Max / Min value, but the OnCurrent calculation and
subsequent population of this text box is difficult - or is it?
Regards
Karl